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: