UFN_MKTPOSTALTEMPLATE_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


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

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