CONTINUE Statement

Restarts the enclosing WHILE or FOR loop. It is an error to call CONTINUE outside of a WHILE or FOR loop.

Syntax

CONTINUE;

Example

-- Prints the odd numbers from 1 to 9.
DECLARE @counter = 0;
WHILE @counter < 10 BEGIN
    SET @counter = @counter + 1;
    IF @counter % 2 = 0  -- True for even numbers.
        CONTINUE;
    PRINT @counter;
END

See Also

• WHILE Statement
• FOR Statement