UFN_TRANSLATIONFUNCTION_SALESORDER_GETSEQUENCEID

Return

Return Type
nvarchar(20)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


                create function dbo.UFN_TRANSLATIONFUNCTION_SALESORDER_GETSEQUENCEID 
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(20)
                as
                begin
                    declare @SEQUENCE nvarchar(50);
                    select @SEQUENCE = convert(nvarchar(20), [SEQUENCEID]) 
                    from dbo.[SALESORDER] 
                    where [ID] = @ID;

                    return @SEQUENCE;
                end