UFN_PDACCOUNTSEGMENTMAP_GETLONGDESCRIPTION
Returns long description
Return
| Return Type |
|---|
| nvarchar(512) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LONGID | nvarchar(36) | IN | |
| @ISDEFAULT | bit | IN |
Definition
Copy
CREATE function dbo.UFN_PDACCOUNTSEGMENTMAP_GETLONGDESCRIPTION(@LONGID nvarchar(36),@ISDEFAULT bit)
returns nvarchar(512)
with execute as caller
as begin
declare @ReturnValue as nvarchar(512);
-- do work here and return a value
if @ISDEFAULT = 1
set @ReturnValue = '<Not Used>'
else
Select @ReturnValue = LONGDESCRIPTION from PDACCOUNTSEGMENTMAPPINGVIEW WHERE LONGDESCRIPTIONID = @LONGID
return @ReturnValue
end