"UpdateRole" Stored Procedure

This stored procedure is used by the Roles administration page to update the display name of the specified role. The input parameter is the RoleID.

    CREATE PROCEDURE UpdateRole
    (
        @RoleID      int,
        @RoleName    nvarchar(50)
    )
    AS

    UPDATE
        Roles

    SET
        RoleName = @RoleName

    WHERE
        RoleID = @RoleID
        

Roles:  Each record in the Roles table defines a unique role in the selected portal. Users are added to a role via the UserRoles lookup value table.

The primary key in this table is the RoleID identity field.