September 30, 2020
sql-database

How to use while loop in SQL statement?

This article describes about SQL While Loop and how to use it? Summary of the article:

  • What is While Loop?
  • Example of WHILE Loop in SQL
  • Example of WHILE Loop with BREAK keyword
  • Example of WHILE Loop with CONTINUE keyword

What is While Loop?
While loop is one kind of loop statement used in SQL.

Example of WHILE Loop in SQL
SQL While loop example is given bellow:

DECLARE @StartPointer INT
SET @StartPointer = 1
WHILE (@StartPointer <=5)
BEGIN
      PRINT @StartPointer
      SET @StartPointer = @StartPointer + 1
END

Result:
1
2
3
4
5

Example of WHILE Loop with BREAK keyword
SQL While loop example with Break Keyword is given bellow:

DECLARE @StartPointer INT
SET @StartPointer = 1
WHILE (@StartPointer <=5)
BEGIN
	PRINT @StartPointer
	SET @StartPointer = @StartPointer + 1
	IF(@StartPointer=3) BREAK
END

Result:
1
2

Example of WHILE Loop with CONTINUE keyword
SQL While loop example with Continue keyword is given bellow:

DECLARE @StartPointer INT
SET @StartPointer = 1
WHILE (@StartPointer <=5)
BEGIN
	PRINT @StartPointer
	SET @StartPointer = @StartPointer + 1
	CONTINUE
	IF(@StartPointer=3) BREAK --This statement will never executed
END

Result:
1
2
3
4
5

Rashedul Alam

I am a software engineer/architect, technology enthusiast, technology coach, blogger, travel photographer. I like to share my knowledge and technical stuff with others.

View all posts by Rashedul Alam →

Leave a Reply

Your email address will not be published. Required fields are marked *