"GetModuleSettings" Stored Procedure

This stored procedure returns all of settings for the for the specified module. The settings are stored in the ModuleSettings table as a name/value pair.  The input parameter is the ModuleID.

        
    CREATE PROCEDURE GetModuleSettings
    (
        @ModuleID int
    )
    AS

    SELECT
        SettingName,
        SettingValue

    FROM
        ModuleSettings

    WHERE
        ModuleID = @ModuleID
        

ModuleSettings:  Each record in the ModuleSettings table contains a name/value pair that represents a setting used by a module within the portal.  Each setting item contains a ModuleID to permit all settings to be retrieved in a single query.