CONTINUE Statement

Causes an immediate jump back to the start of a WHILE loop.

Syntax

CONTINUE

Comments

Any statements between the CONTINUE 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 CONTINUE
    INSERT INTO TESTDATA VALUES(@I,@V2)
END

If @V2 is greater than 500, starts the next loop iteration, without executing the INSERT statement.

See Also

WHILE statement, BREAK statement.