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