WHILE Loop in SQL Server: Explained

The WHILE loop (WHILE LOOP) is used if you want to run a code repeatedly when the given condition returns TRUE. The article will explain in detail how to use it with a clear syntax and example to make it easier to imagine WHILE in SQL Server.

Syntax

To use WHILE loop in SQL Server, we use the syntax as below:

 WHILE dieukien / * commands to repeat * / 
 BEGIN 
 {. execute command when condition is TRUE .} 
 END; 

As an example,

 DECLARE @Number INT = 1; 
 DECLARE @Total INT = 0; 

 @Number WHILE <= 10 
 BEGIN 
 SET @Total = @Total + @Number; 
 SET @Number = @Number + 1; 
 END 

 PRINT @Total; 

 GO