Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

Community Additions

ADD
Show:
© 2014 Microsoft