UFN_FUNCTIONALAREA_GETID

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy


create function dbo.UFN_FUNCTIONALAREA_GETID (
    @NAME nvarchar(100))
returns uniqueidentifier
with execute as caller
as
begin
    declare @return_value uniqueidentifier
    select @return_value = ID from dbo.FUNCTIONALAREACATALOG where [NAME] = @NAME
    return @return_value
end