Click to See Complete Forum and Search --> : Shortcut Key to execute queries in Sql Server 2005


bank5
03-16-2007, 10:49 AM
I just switch from Sql Server 2000 to 2005. In Query Analyzer (SQL Server 2000) I used the F5 shortcut key all the time to execute queries. Is there a shortcut key in Query Editor (SQL Server 2005) to execute queries?

Also, is there a shortcut key to check the syntax of the sql statement?

One annoying thing is that is the syntax is off, SQL Server 2005 will delete the current query revert back to the previous executed query. Are there anyways to avoid this?

bank5
03-16-2007, 11:03 AM
I just realized that I wasn't in the actual Query Editor window. I had right clicked on a table in the Object Explorer and opened it from there, so that's why the short cut keys weren't working.

When I go to New Query, and execute a query from there, everything works as expected.