UFN_SYSTEMROLE_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SYSTEMROLE_GETNAME (@ID uniqueidentifier) 
returns nvarchar(100)
with execute as caller
as begin
    declare @NAME nvarchar(100);

    select
        @NAME = [NAME]
    from
        dbo.[SYSTEMROLE]
    where
        [ID] = @ID;

    return @NAME;
end