{"id":155,"date":"2019-09-24T07:55:55","date_gmt":"2019-09-24T07:55:55","guid":{"rendered":"http:\/\/sumitjangid.com\/?p=155"},"modified":"2019-09-24T08:03:46","modified_gmt":"2019-09-24T08:03:46","slug":"continue","status":"publish","type":"post","link":"http:\/\/sumitjangid.com\/index.php\/2019\/09\/24\/continue\/","title":{"rendered":"Continue"},"content":{"rendered":"\n

The CONTINUE<\/code> statement stops the current iteration of the loop and starts the new one. The following illustrates the syntax of the CONTINUE<\/code> statement:<\/p>\n\n\n\n
1234567<\/td>WHILE Boolean_expressionBEGIN    — code to be executed<\/em>    IF condition        CONTINUE;    — code will be skipped if the condition is met<\/em>END<\/td><\/tr><\/tbody><\/table>\n\n\n\n

In this syntax, the current iteration of the loop is stopped once the condition evaluates to TRUE<\/code>. The next iteration of the loop will continue until the Boolean_expression<\/code> evaluates to FALSE<\/code>.<\/p>\n\n\n\n

Similar to the BREAK<\/code> statement, the CONTINUE<\/code> statement is often used in conjunction with an IF...ELSE<\/code> statement. Note that this is not mandatory though.<\/p>\n\n\n\n

SQL Server CONTINUE<\/code> example<\/h2>\n\n\n\n

The following example illustrates how the CONTINUE<\/code> statement works.<\/p>\n\n\n\n
123456789<\/td>DECLARE @counter INT = 0; WHILE @counter < 5BEGIN    SET @counter = @counter + 1;    IF @counter = 3        CONTINUE;     PRINT @counter;END<\/td><\/tr><\/tbody><\/table>\n\n\n\n

Here is the output:<\/p>\n\n\n\n
1234<\/td>1245<\/td><\/tr><\/tbody><\/table>\n\n\n\n

In this example:<\/p>\n\n\n\n

First, we declared a variable<\/a> named @counter<\/code> and set its value to zero.<\/p>\n\n\n\n

Then, the WHILE<\/a><\/code> loop started. Inside the WHILE<\/code> loop, we increased the counter by one in each iteration. If the @counter<\/code> was three, we skipped printing out the value using the CONTINUE<\/code> statement. That\u2019s why in the output, you do not see the number three is showing up.<\/p>\n","protected":false},"excerpt":{"rendered":"

The CONTINUE statement stops the current iteration of the loop and starts the new one. The following illustrates the syntax of the CONTINUE statement: 1234567 WHILE Boolean_expressionBEGIN    — code to be executed    IF condition        CONTINUE;    — code will be skipped if the condition… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,18,19],"tags":[],"_links":{"self":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/155"}],"collection":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":1,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":156,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions\/156"}],"wp:attachment":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}