USP_RECORDOPERATON_SCHEMENAMEPROMPT

            create procedure "USP_RECORDOPERATON_SCHEMENAMEPROMPT"
            (
            @ID uniqueidentifier,
            @NAME nvarchar(100)=null output 
            )
            as
                set nocount on; 
                select @NAME = NAME
                From dbo.BATCHNUMBERINGSCHEME
                where ID = @ID; 

                return 0;