BREAK (Transact-SQL)
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

BREAK (Transact-SQL)

Exits the innermost loop in a WHILE or IF…ELSE statement. 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.

© 2016 Microsoft