BREAK Statement

Causes an immediate exit from a WHILE loop.

Syntax

BREAK

Comments

The BREAK statement causes an immediate exit from the innermost enclosing WHILE loop. Any statements between the BREAK statement and the end of the loop are skipped.

Example

SET @I = 0
SET @V1 = SECOND(CURTIME())+1
WHILE @I<10
BEGIN
    SET @I = @I+1
    SET @V2 = @V1*@I + @V1/@I
    IF @V2>500 BREAK
    INSERT INTO TESTDATA VALUES(@I,@V2)
END

Breaks out of the loop if @V2 is greater than 500.

See Also

WHILE statement, CONTINUE statement.