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)
Begin
    print(@i);
    set @i=@i+1;
end

Output:


Comments

Archive

Contact Form

Send