How can I execute a single query in SQL Server Management Studio?

Question

Background: I'm using SQL Server Management Studio 2008 and I have a query window open that contains multiple queries.

Is there a keyboard shortcut that will allow me to execute a single query without highlighting the query I would like to run first? Some other SQL tools have shorcuts that run the query that is under the cursor, which keeps the hands on the keyboard, and away from the mouse.

Thanks everyone.

Answer 1

I just mark the line I'm on (shift-down or shift-end), and then click ALT-X.

Answer 2

I did some searching and was unable to find any keyboard shortcuts for executing individual lines in SSMS. There is a reference online though.

http://msdn.microsoft.com/en-us/library/ms174205.aspx

Personally I just highlight the row in question (shift-end or shift-down, etc.) and hit F5.

Answer 3

Highlight the query you want to run, then F5.

Answer 4

The usual Shift+Arrow or Shift+PgUp/PgDown that apply to most or all Windows apps...

Then I use CTRL-E to execute

Answer 5

I don't think Management Studio allows this, because then you would not be able to run multiple queries at once if the cursor was on any one of them, which could get annoying.