"UpdateTabOrder" Stored Procedure

Description:

This stored procedure is used by the Tabs administration page to set the position of the specified tab with respect to other tabs in the portal. The input parameters include the item's primary key (TabID), plus it's TabOrder setting.

Definition:

    CREATE PROCEDURE UpdateTabOrder
    (
        @TabID           int,
        @TabOrder		 int
    )
    AS

    UPDATE
        Tabs

    SET
        TabOrder = @TabOrder

    WHERE
        TabID = @TabID
        
Database Tables Used:

Tabs:  Each record in the Tabs table defines the name and access permissions for a tab in the selected portal. The primary key in this table is the TabID identity field.