BREAK (Control Interrupt) command in SQL Server
The Break command used to exit the loop does not specify a stop condition or you want to stop the loop on condition that you specify and execute the statements following the loop statement END.
The Break command used to exit the loop does not specify a stop condition or you want to stop the loop on condition that you specify and execute the statements following the END command of the loop.
Syntax
To use the command to interrupt BREAK control in SQL Server, we use the following syntax:
BREAK;
There are no parameters and arguments in the BREAK statement.
Note:
- You use BREAK to end the WHILE loop early.
- If in the code there is WHILE nested LOOP, BREAK will terminate the nearest WHILE loop.
For example
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;
END
PRINT @Total;
GO
In this example using the BREAK statement, the WHILE loop will end when @Number reaches value 5.
Previous article: FOR loop in SQL Server
Next lesson: CONTINUE command in SQL Server
Update 25 May 2019
You should read it
- Break and continue commands in Python
- How to delete the entire Section Break in Word
- What happens when we break our fingers 'cracked'?
- How to Break a Chain
- Page break in Word - Instructions on how to break a page in Word 2007, 2010, 2013, 2016
- Out of love but afraid to express? Don't worry, there's Breakup Shop
- How to break Excel Password without software
- Word 2013 full-text tutorial (Part 12): How to break pages, paragraph breaks
- How to crack Windows 10 password, how to break password on Windows 10
- No need to be a singer, you can still smash a glass of water with singing
- Page Break error in Excel and instructions on how to fix it
- GOTO command in SQL Server