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