UFN_QUERYVIEW_GETBUSINESSPROCESSOUTPUTCAPTION

Return

Return Type
nvarchar(255)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


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

    return coalesce((select [CAPTION] from dbo.[BUSINESSPROCESSVIEW] where [QUERYVIEWCATALOGID] = @ID), '')
end