This stored procedure returns the desktop HTML and Mobile text for the specified Html module. The input parameter is the ModuleID.
Definition:CREATE PROCEDURE GetHtmlText ( @ModuleID int ) AS SELECT * FROM HtmlText WHERE ModuleID = @ModuleIDDatabase Tables Used:
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.