Transact-SQL Reference

BREAK

Exits the innermost WHILE loop. Any statements following the END keyword are ignored. BREAK is often, but not always, activated by an IF test.

See Also

Control-of-Flow Language

WHILE