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.