BREAK (TSQL Statement)
Execution jumps out of the WHILE
loop.
The execution resumes at the next statement following the loop.
Syntax
BREAK
Remarks
In nested loops, BREAK
exits only from the loop in which it occurs (innermost loop).
Example
DECLARE @i INT = 0;
WHILE @i < 1000
BEGIN
PRINT @i;
IF @i = 4
BREAK;
SET @i += 1;
END
PRINT 'End';
The result is:
0
1
2
3
4
End