UFN_MKTSOURCECODE_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_MKTSOURCECODE_GETNAME
(
  @ID uniqueidentifier
)
returns nvarchar(100)
as begin
  if @ID is null
    return '';

  return coalesce((select [NAME] from dbo.[MKTSOURCECODE] where [ID] = @ID), '');
end