UFN_QUERYVIEW_GETNAME

Return

Return Type
nvarchar(255)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_QUERYVIEW_GETNAME(@ID uniqueidentifier)
returns nvarchar(255)
as begin
    if @ID is null
        return ''

    return coalesce((select [DISPLAYNAME] from dbo.[QUERYVIEWCATALOG] where [ID] = @ID), '')
end