Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: SQL
Expertise: Beginner
Aug 12, 2008



Application Security Testing: An Integral Part of DevOps

Executing Marked Text in SQL Server Management Studio

In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute. For instance, sometimes I create a SQL script to delete all the data in a specific database while I am testing the application. I don't want to accidentally run the file and delete all the data when I shouldn't, so I comment out all the delete statements. To execute them when I need to, instead of uncommenting them, I place the cursor right between the "--" and the "DELETE" keyword, press and hold the Alt key, left click and select all the statements I need, and then execute them.

For instance, suppose you have the following statements:

You would 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.

Notice how you have to drag the cursor all the way to the "#" symbol even when the last word was "CUSTOMER." This is because a rectangle is formed and you need to cover the fourth line, which is the longest one.

Cindy Rodriguez
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date