Sequence Number Generation + sqlserver

CREATE @intShowVersion @strRotationName @strTrainOperator @strArrDate @strOut PROCEDURE [dbo].[GenTrainRandNo] tinyint, varchar(20), varchar(50), datetime, varchar(15) output AS SET NOCOUNT ON IF ELSE (@intShowVersion = 1 ) BEGIN SELECT VERSION='$Revision: 1 $' RETURN 0 END BEGIN DECLARE @intError AS INTEGER DECLARE @strYear AS VARCHAR(4) DECLARE @bitUseYear AS BIT DECLARE @strPrefix AS VARCHAR(10) DECLARE @intCurrentVal AS INTEGER DECLARE @strLen AS INTEGER DECLARE @strCurrentVal VARCHAR(15) SET ......

Posted On Thursday, January 15, 2009 8:50 PM