UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_GETNAME

Return

Return Type
nvarchar(50)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


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

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