UFN_SOLICITCODE_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


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

  select @NAME = isnull(DESCRIPTION, '')
  from dbo.SOLICITCODE
  where ID = @ID;

  return @NAME;
end