Restarts the while loop. continue is often activated by an if test.
while boolean_expression statement break statement continue
If the average price is less than $30, double the prices. Then, select the maximum price. If it is less than or equal to $50, restart the while loop and double the prices again. If the maximum price is more than $50, exit the while loop and print a message:
while (select avg(price) from titles) < $30 begin update titles set price = price * 2 select max(price) from titles if (select max(price) from titles) > $50 break else continue end begin print "Too much for the market to bear" end
continue restarts the while loop, skipping any statements after continue.
SQL92 – Compliance level: Transact-SQL extension.
continue permission defaults to all users. No permission is required to use it.
Commands break, while