How to use while loop in sql server?

Question

Amit Singh · Answer

----------This is loop example in sql server----------------
Declare @maxNo int
Declare @i int
set @maxNo=4
set @i=1
print 'Output'
---Use while loop----
while(@i<=@maxNo)
begin
    print @i
    set @i=@i+1
end
--output------
1
2
3
4

interview

How to use while loop in sql server?

Can you answer this question?

1 Answers