Generate Sequential Number in SQL Server

 

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