UFN_NAMEFORMAT_GETFORMATTEDNAME
Return
Return Type |
---|
nvarchar(700) |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_NAMEFORMAT_GETFORMATTEDNAME(@ID UNIQUEIDENTIFIER)
returns nvarchar(700) with execute as caller
as
begin
declare @NAME nvarchar(700), @NAMEFORMATFUNCTIONID uniqueidentifier, @CONSTITUENTID uniqueidentifier;
select
@NAME = CUSTOMNAME,
@NAMEFORMATFUNCTIONID = NAMEFORMATFUNCTIONID,
@CONSTITUENTID = CONSTITUENTID
from
dbo.NAMEFORMAT where NAMEFORMAT.ID = @ID;
if @NAMEFORMATFUNCTIONID is not null
set @NAME = dbo.UFN_NAMEFORMAT_FROMID(@NAMEFORMATFUNCTIONID, @CONSTITUENTID)
return @NAME;
END