Thursday, 12 May 2016

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:



WHAT OTHERS ARE READING/RELATED TO THIS:

0 comments:

Post a Comment