UFN_CAMPAIGN_GETNAME

Retrieve the name of the campaign with the given ID.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CAMPAIGN_GETNAME
            (
                @CAMPAIGNID uniqueidentifier
            ) returns nvarchar(100)
            as 
            begin
                declare @CAMPAIGNNAME nvarchar(100)

                select @CAMPAIGNNAME=NAME
                from CAMPAIGN
                where ID=@CAMPAIGNID

                return @CAMPAIGNNAME
            end