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:


Post a Comment

0 Comments
* Please Don't Spam Here. All the Comments are Reviewed by Admin.