Here is the small example on how to generate sequential number in SQL Server.
DECLARE @cnt INT
SET @cnt=0
WHILE (@CNT<=10)
BEGIN
PRINT @CNT
SET @CNT=@CNT+1
END
Here is the small example on how to generate sequential number in SQL Server.
DECLARE @cnt INT
SET @cnt=0
WHILE (@CNT<=10)
BEGIN
PRINT @CNT
SET @CNT=@CNT+1
END