Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Exits a compound statement or loop.
The BREAK statement is a control statement that allows you to leave a loop. Execution resumes at the first statement after the loop.
Not in the standard.
In this example, the BREAK statement breaks the WHILE loop if the most expensive product has a price above $50. Otherwise, the loop continues until the average price is greater than or equal to $30:
WHILE ( SELECT AVG( UnitPrice ) FROM Products ) < $30 BEGIN UPDATE GROUPO.Products SET UnitPrice = UnitPrice + 2 IF ( SELECT MAX(UnitPrice) FROM Products ) > $50 BREAK END