"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 UpdateHtmlText
    (
        @ModuleID      int,
        @DesktopHtml   ntext,
        @MobileSummary ntext,
        @MobileDetails ntext
    )
    AS

    IF NOT EXISTS (
        SELECT 
            * 
        FROM 
            HtmlText 
        WHERE 
            ModuleID = @ModuleID
    )
    INSERT INTO HtmlText (
        ModuleID,
        DesktopHtml,
        MobileSummary,
        MobileDetails
    ) 
    VALUES (
        @ModuleID,
        @DesktopHtml,
        @MobileSummary,
        @MobileDetails
    )
    ELSE
    UPDATE
        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.