SQL Server EXIT or BREAK from WHILE Loop with Example

Introduction

Here I will explain how to exit from while loop in SQL Server or how to break from while loop in SQL Server with example.

Description

In previous articles I explained While Loop Example in SQL Server, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to break or exist while loop in SQL Server with example.

To use while loop in stored procedure we need to write the query like this

DECLARE @loop INT SET @loop = 0 WHILE @loop <= 10 BEGIN    SET @loop = @loop + 1    PRINT @loop END

If we run above query we will get output like as shown below

Output: 

If we want to Exit or Break from while loop we need to write the query like this

DECLARE @loop INT SET @loop = 0 WHILE @loop <= 10 BEGIN    SET @loop = @loop + 1    IF @loop>7 BREAK PRINT @loop END

If we run above query we will get output like as shown below

Output: 

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email