How to use while loop in sql server? Amit Singh367719-Jan-2012mssql servermssql server Updated on 20-Sep-2020
Amit Singh
19-Jan-2012Declare @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