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.