Commonly used Keyboard Shortcuts in SQL Server Management Studio (SSMS)

Here are some commonly used keyboard shortcuts in SQL Server Management Studio (SSMS).

Qn. How to Start SQL Server Management Studio (SSMS) from Run Prompt?

Ans. Go to Start -> Run. Type "sqlwb" and click "OK". This will launch SQL Server Management Studio.

For shortcuts to invoke SQL Server Client Applications (SSMS, BIDS), Click Here.

Qn. How to comment multiple lines of SQL statements in SQL Server Management Studio?

Ans. Select the line(s) of code to be commented and then press "CTRL+K" & "CTRL+C" one after the other. This will comment the selected line(s) of SQL Statements.

Qn. How uncomment multiple lines of SQL statements in SQL Server Management Studio?

Ans. Select the line(s) of code to be commented and then press "CTRL+K" & "CTRL+U" one after the other. This will uncomment the selected line(s) of SQL Statements.

Qn. What is the Shortcut for parsing SQL Queries in SQL Server Management Studio?

Ans. Parsing an SQL Server will check for any syntactical errors in the selected set of SQL Statements. To parse SQL Statement(s) in SQL Server Management Studio select the SQL Statement(s) and then press "CTRL + F5"

Qn. What is the Shortcut for running/executing SQL queries in SQL Server Management Studio?

Ans. Select the SQL Statement(s) to be executed and then press any of the following to execute the selected SQL Statement(s):

1. F5

2. CTRL + E

Qn. How to navigate between query pane and results pane in SQL Server Management Studio?

Ans. The following are the shortcuts for navigating between the query pane and the results pane in SQL Server Management Studio:

• To move from Query pane to the results pane press "F6"
• To move from results pane to the Query pane press "SHIFT + F6"

Note:- The above listed shortcuts are applicable for SQL Server 2005 Management Studio. Some of these shortcuts might not work with SQL Server 2008 Management Studio.

Readers Feedback:

Did you like this article? If Yes, then please share it: | More Options

Did you like my blog? If Yes, then please help spread the word by sharing this blog with your colleagues, friends, & anyone else in the MSBI Space: Like us on Facebook , Follow us on Twitter .