In this article, we will learn how to use the WHILE loop in SQL.
The WHILE loop loops through a block of code as long as a specified condition is not false.
The WHILE loop is handy because they save time, reduces errors, and they make code more readable.
Syntax
WHILE <condition>
BEGIN
-- Statement block
END;
Example
The subsequent statement would print 1 to 10 digits:
DECLARE @i INT = 1; WHILE @i <= 10 BEGIN PRINT @i; SET @i = @i + 1; END;
Also, check How To Use Case Statement In SQL
