Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Restarts a loop.
CONTINUE [ statement-label ]
The CONTINUE statement is a control statement that restarts a loop. Execution continues at the first statement in the loop.
When CONTINUE appears within a set of statements using Transact-SQL, do not use statement-label.
Not in the standard.
CONTINUE without a statement label is supported by SAP Adaptive Server Enterprise.
The following fragment shows how the CONTINUE statement restarts a loop. This example displays the odd numbers between 1 and 10.
BEGIN DECLARE i INT; SET i = 0; lbl: WHILE i < 10 LOOP SET i = i + 1; IF mod( i, 2 ) = 0 THEN CONTINUE lbl END IF; MESSAGE 'The value ' || i || ' is odd.' TO CLIENT; END LOOP lbl; END