fnGetFormDisplayForm_DisplayName

Return

Return Type
nvarchar(255)

Parameters

Parameter Parameter Type Mode Description
@FormGuid uniqueidentifier IN
@ContentID int IN

Definition

Copy

        create function dbo.fnGetFormDisplayForm_DisplayName
        (
            @FormGuid    uniqueidentifier,
            @ContentID    int
        )
        returns nvarchar(255) as
        begin
            declare @DisplayName nvarchar(255)
            select @DisplayName = DisplayName from dbo.FormDisplayForms
            where FormGuid = @FormGuid and ContentID = @ContentID

            if @@ROWCOUNT = 0 
                select @DisplayName = ''

            return @DisplayName
        end