"UpdateHtmlText" Stored Procedure

This stored procedure is used by the HtmlModule edit page to apply changes to an existing HtmlText item. The input parameters include the item's primary key (ModuleID), plus Desktop HTML, Mobile Summary text and Mobile details text.

    
   CREATE PROCEDURE Portal_UpdateHtmlText
   (
       @ModuleID      int,
       @DesktopHtml   ntext,
       @MobileSummary ntext,
       @MobileDetails ntext
   )
   AS
   
   IF NOT EXISTS (
       SELECT 
           * 
       FROM Portal_HtmlText 
       WHERE 
           ModuleID = @ModuleID
   )
   INSERT INTO Portal_HtmlText (
       ModuleID,
       DesktopHtml,
       MobileSummary,
       MobileDetails
   ) 
   VALUES (
       @ModuleID,
       @DesktopHtml,
       @MobileSummary,
       @MobileDetails
   )
   ELSE
   UPDATE Portal_HtmlText
   
   SET
       DesktopHtml   = @DesktopHtml,
       MobileSummary = @MobileSummary,
       MobileDetails = @MobileDetails
   
   WHERE
       ModuleID = @ModuleID
        

HtmlText:  Each record in the HtmlText holds the HTML and text associated with a specific Html module.  Each of the text field - DesktopHtml, MobileSummary, and MobileDetails - is stored in a SQL Unicode text field, and can hold up to 1,073,741,823 characters.

The primary key in this table is the ModuleID field.