UFN_APPSETTING_GET

Return

Return Type
nvarchar(1024)

Parameters

Parameter Parameter Type Mode Description
@NAME nvarchar(100) IN

Definition

Copy


CREATE function dbo.UFN_APPSETTING_GET
(
    @NAME nvarchar(100)
)
returns nvarchar(1024)

with execute as caller
as begin

    declare @VALUE nvarchar(1024);

    select @VALUE = VALUE
    from dbo.APPSETTING
        where NAME = @NAME;

    return @VALUE;

end