"UpdatePortalInfo" 存储过程

描述:

This 存储过程 is used by the Site Settings administration page to set the portal's display name, and whether the edit button should alway be shown for all modules in the portal.

定义:


    CREATE PROCEDURE UpdatePortalInfo
    (
        @PortalID           int,
        @PortalName         nvarchar(50),
        @AlwaysShowEditButton bit 
    )
    AS

    UPDATE
        Portals

    SET
        PortalName = @PortalName,
        AlwaysShowEditButton = @AlwaysShowEditButton

    WHERE
        PortalID = @PortalID

使用的数据库中的表:

Portals: The portals table holds site-level settings. The primary key in this table is the PortalID identity field.