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