SQL program to generate sequence numbers using While Loop

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 447
The below program will do so

DECLARE 
@i INT = 1,
@maxLimit INT = 1000000

WHILE (@i <= @maxLimit)
BEGIN
PRINT(@i)
SET @i += 1
END

Comments or Responses

Login to post response