Following is very simple example of WHILE Loop with BREAK and CONTINUE. USE AdventureWorks; ... BEGIN ...
blog.sqlauthority.com