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
@ and
# 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).
