"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 Portal_GetHtmlText
   (
       @ModuleID int
   )
   AS
   
   SELECT
       *
   
   FROM Portal_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.