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

SQL Server BREAK<\/code> statement overview<\/h2>\n\n\n\n

In the previous tutorial, you have learned how to use the WHILE<\/a><\/code> statement to create a loop. To exit the current iteration of a loop, you use the BREAK<\/code> statement.<\/p>\n\n\n\n

The following illustrates the typical syntax of the BREAK<\/code> statement:<\/p>\n\n\n\n
1234567<\/td>WHILE Boolean_expressionBEGIN    — statements<\/em>   IF condition        BREAK;    — other statements    <\/em>END<\/td><\/tr><\/tbody><\/table>\n\n\n\n

In this syntax, the BREAK<\/code> statement exit the WHILE<\/code> loop immediately once the condition<\/code>  specified in the IF<\/a><\/code> statement is met. All the statements between the BREAK<\/code> and END<\/code> keywords are skipped.<\/p>\n\n\n\n

Suppose we have a WHILE<\/code> loop nested inside another WHILE<\/code> loop:<\/p>\n\n\n\n
123456789<\/td>WHILE Boolean_expression1BEGIN    — statement<\/em>    WHILE Boolean_expression2    BEGIN        IF condition            BREAK;    ENDEND<\/td><\/tr><\/tbody><\/table>\n\n\n\n

In this case, the BREAK<\/code> statement only exits the innermost loop in the WHILE<\/code> statement.<\/p>\n\n\n\n

Note that the BREAK<\/code> statement can be used only inside the WHILE<\/code> loop. The IF<\/code> statement is often used with the BREAK<\/code> statement but it is not required.<\/p>\n\n\n\n

SQL Server BREAK<\/code> statement example<\/h2>\n\n\n\n

The following example illustrates how to use the BREAK<\/code> statement:<\/p>\n\n\n\n
123456789<\/td>DECLARE @counter INT = 0; WHILE @counter <= 5BEGIN    SET @counter = @counter + 1;    IF @counter = 4        BREAK;    PRINT @counter;END<\/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, we used the WHILE<\/code> statement to increases the @counter<\/code> by one in each iteration and print out the @counter<\/code>\u2018s value as long as the value of the @counter<\/code> is less than or equal to five.<\/p>\n\n\n\n

Inside the loop, we also checked if the value of @counter<\/code> equals four, then we exited the loop. In the fourth iteration, the value of the counter reached 4, then the loop is terminated. Also, the PRINT<\/code> statement after the BREAK<\/code> statement was skipped.<\/p>\n","protected":false},"excerpt":{"rendered":"

SQL Server BREAK statement overview In the previous tutorial, you have learned how to use the WHILE statement to create a loop. To exit the current iteration of a loop, you use the BREAK statement. The following illustrates the typical syntax… <\/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\/153"}],"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=153"}],"version-history":[{"count":1,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":154,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/posts\/153\/revisions\/154"}],"wp:attachment":[{"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/categories?post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sumitjangid.com\/index.php\/wp-json\/wp\/v2\/tags?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}