How to use while loop in sql server?
Ask by Amit Singh
Updated 20 Sep 2020
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