Do you know that you can add, specifically surround your code with BEGIN/END, IF, and WHILE statements using a menu item without writing them? Yes, with Management Studio, it is possible. Here are the steps for doing it;
Assume that you have the below code that needs to be repeated based on a condition;
All you have to do is, select the code needs to be surrounded and press Ctrl+K and Ctrl+S (Just press Ctrl and hold, and press K first and then S). This is what happen when you do it;
Select WHILE and press Tab key. This is what you should see;
Set the condition as you need now. This shortcut can be opened using the context menu as well.