Print 1 to 10 Using While Loop in SQL Server : Interview Question
Write down the T-SQL Script to print then number from 1 to 10? Ans: declare @i int ; set @i = 1 ; while ( @i <= 10 ) Be...
https://www.interviewquestionspdf.com/2016/05/print-1-to-10-using-while-loop-in-sql.html
Write down the T-SQL Script to print then number from 1 to 10?
Ans:
declare @i int;
Ans:
declare @i int;
set @i=1;
while(@i<=10)
Begin
print(@i);
set @i=@i+1;
end
Output:
