CONTINUE in SQL Server Command: CONTINUE Command in SQL Server

The CONTINUE command is used to give command execution authority to the last expression of the loop. That means upside-down to the top of the loop, all the commands that follow in the loop containing CONTINUE will be ignored without execution. You will detail how to use this command in SQL Server.

Syntax

To use the CONTINUE statement in SQL Server, we use the following syntax:

 TIẾP TỤC; 

Note:

• There are no parameters and arguments in the CONTINUE statement.
• You use the CONTINUE statement to return to the WHILE loop and execute its subsequent conditions.

For instance,

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

 @Number WHILE <= 10 
 BEGIN 
 IF @NUMBER = 5 
 BREAK; 

 ELSE 
 SET @Total = @Total + @Number; 
 SET @Number = @Number + 1; 
 TIẾP TỤC; 
 END; 

 END; 

 PRINT @Total; 
 GO 

Next lesson: GOTO command in SQL Server