UFN_EXCHANGEBATCH_GETCODETABLEENTRYID

Attempts to get the ID value from the specified code table using the specified code table value.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CODETABLENAME	nvarchar(128)	IN
@CODETABLEVALUE	nvarchar(100)	IN

Definition

Copy



            create function dbo.UFN_EXCHANGEBATCH_GETCODETABLEENTRYID
            (
                @CODETABLENAME nvarchar(128),
                @CODETABLEVALUE nvarchar(100)
            )
            returns uniqueidentifier
            as 
            begin
                declare @ID uniqueidentifier
                declare @SQL nvarchar(200)

                set @SQL = 'select @ID_out = dbo.ufn_' + @CODETABLENAME + '_getid(@value_in)';
                exec sp_executesql @SQL, N'@VALUE_IN nvarchar(100), @ID_OUT uniqueidentifier output', @ID_OUT = @ID output, @VALUE_IN = @CODETABLEVALUE;

                return @ID;
            end