UFN_IDSET_GETID

Returns the primary key for an id set based on the name.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@IDSETNAME	nvarchar(100)	IN

Definition

Copy



create function dbo.UFN_IDSET_GETID(@IDSETNAME nvarchar(100)) returns uniqueidentifier with execute as caller
as
begin
    declare @ID uniqueidentifier                
    select @ID = ID from dbo.IDSETREGISTER where NAME = @IDSETNAME                     
    return @ID
end