BREAK (Transact-SQL)

Exits the innermost loop in a WHILE statement or an IF…ELSE statement inside a WHILE loop. Any statements appearing after the END keyword, marking the end of the loop, are executed. BREAK is frequently, but not always, started by an IF test.

See Also

Reference

Control-of-Flow Language (Transact-SQL)

WHILE (Transact-SQL)

IF...ELSE (Transact-SQL)