In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute. For instance, suppose you have the following statements:
--@DELETE FROM ORDERDETAIL
--DELETE FROM ORDER
--DELETE FROM PRODUCT
--DELETE FROM PRODUCTCATEGORY
--DELETE FROM CUSTOMER #
You'd place the cursor where the @
symbol is, press and hold the Alt key, left click with the mouse, and drag the cursor all the way to where the #
symbol is. The @
symbol are included here to show you the exact places, they shouldn't be included in your statement. Also keep in mind that this selection method creates a rectangle so you have to select everything to cover the longest statement.
Note how you have to drag the cursor all the way to the # symbol even when the last word was CUSTOMER. This is because Alt-dragging creates a rectangle of marked text, and you need to make the rectangle wide enoungh to select the fourth line (the longest one).