UFN_IDSET_MAKEFUNCTIONNAME
Return
Return Type |
---|
nvarchar(164) |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PREFIX | nvarchar(64) | IN | |
@ID | uniqueidentifier | IN | |
@SUFFIX | nvarchar(64) | IN |
Definition
Copy
create function dbo.UFN_IDSET_MAKEFUNCTIONNAME(@PREFIX nvarchar(64), @ID uniqueidentifier, @SUFFIX nvarchar(64))
returns nvarchar(164)
with execute as caller
as
begin
return @PREFIX + replace(cast(@ID as nvarchar(36)), '-', '_') + @SUFFIX
end