UFN_CODETABLECATEGORY_GETID

Return

Return Type
uniqueidentifier

Parameters

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

Definition

Copy



create function dbo.UFN_CODETABLECATEGORY_GETID(@Description nvarchar(100))
returns uniqueidentifier with execute as caller
as
begin
    declare @r uniqueidentifier
    select @r=ID from dbo.CODETABLECATEGORY where DESCRIPTION = @Description
    return @r
end