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:


Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

0 comments:

Post a Comment