continue

Restarts the while loop. continue is often activated by an if test.

Syntax

while boolean_expression 
		statement 
	break 
		statement 
continue

Examples

Usage

continue restarts the while loop, skipping any statements after continue.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

No permission is required to use continue.

Related reference
break
while