Let's declare a variable i and set the value is 10.
In second line we write a while loop.
declare @i int=10
while(@i<=20)
begin
print @i
set @i=@i+1
end
While loop in SQL
In this snippet we learn how to write while loop in sql server.
Loading
In this snippet we learn how to write while loop in sql server.
declare @i int=10
while(@i<=20)
begin
print @i
set @i=@i+1
end