USP_SIMPLEDATALIST_SYSTEMROLES

This simple datalist returns all system roles in the system.

Definition

Copy


CREATE procedure dbo.USP_SIMPLEDATALIST_SYSTEMROLES
as
    set nocount on;

    select
        [ID] as VALUE,
        [NAME] as LABEL
    from
        dbo.SYSTEMROLE
    order by
        [NAME];

    return 0;