Post
Ask Question

While loop in SQL

Let's declare a variable i and set the value is 10.
In second line we write a while loop.
  1. declare @i int=10  
  2. while(@i<=20)  
  3. begin  
  4. print @i  
  5. set @i=@i+1  
  6. end