How To Use WHILE Loop In SQL

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

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.