"GetHtmlText" Stored Procedure

This stored procedure returns the desktop HTML and Mobile text for the specified Html module.  The input parameter is the ModuleID.

    CREATE PROCEDURE GetHtmlText
    (
        @ModuleID int
    )
    AS

    SELECT
        *

    FROM
        HtmlText

    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.