"GetModuleSettings" 存储过程

描述:

This 存储过程 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.