Handy Query Analyzer and SSMS shortcuts - Part II

April 28, 2008 | Leave a Comment

Shortcut Function   Shortcut Function
ALT+BREAK Cancel a query   CTRL+SHIFT+F2 Clear all bookmarks
ALT+F1 Database object information   CTRL+SHIFT+INSERT Insert a template
ALT+F4 Exit   CTRL+SHIFT+L Make selection lowercase
CTRL+A Select all   CTRL+SHIFT+M Replace template parameters
CTRL+B Move the splitter   CTRL+SHIFT+P Open
CTRL+C Copy   CTRL+SHIFT+R Remove comment
CTRL+D Display results in grid format   CTRL+SHIFT+S Show client statistics
CTRL+Delete Delete through the end of the line   CTRL+SHIFT+T Show server trace
CTRL+E Execute query   CTRL+SHIFT+U Make selection uppercase
CTRL+F Find   CTRL+T Display results in text format
CTRL+F2 Insert/remove bookmark   CTRL+U Change database
CTRL+F4 Disconnect   CTRL+V Paste
CTRL+F5 Parse query and check syntax   CTRL+W Window selector
CTRL+G Go to line   CTRL+X Delete
CTRL+H Replace   CTRL+Z Undo
CTRL+I Index Tuning Wizard   F1 Help for Query Analyzer
CTRL+K Display/hide execution plan   F2 Move to next bookmark
CTRL+L Display execution plan   F3 Repeat last search
CTRL+N New query window   F4 Object Search
CTRL+O Connect   F5 Execute a query
CTRL+P Print   F6 Switch between query and result panes
CTRL+R Show/Hide results pane   F8 Show/hide Object Browser
CTRL+S Save   SHIFT+F1 Transact-SQL help
CTRL+SHIFT+0 Show options   SHIFT+F2 Move to previous bookmark
CTRL+SHIFT+C Comment out code   SHIFT+TAB Decrease indent
CTRL+SHIFT+DEL Clear the active Editor pane   SHIFT+F6 Switch panes
CTRL+SHIFT+F Save results to file   TAB Increase indent

Posted by | Filed Under SQL 

Handy Query Analyzer and SSMS shortcuts

April 28, 2008 | Leave a Comment

Use them every day :

Shortcuts:

2000 – isqlw –To open a query analyzer in 2000

2005 – sqlwb—To open SSMS in 2005 (Not Query analyzer For New Query use Alt+N)

2005 –ssmsee—TO open SSMS in 2005 (Express Edition)

The most commonly used keyboard shortcuts in the SQL Server Management Studio (SSMS).

Run and then SqlWb.exe to launch SQL Server Management Studio

Results in Grid
Ctrl + D

Change database
Ctrl + U

Results in Text
Ctrl + T

Execute Query
Ctrl + E or F5

Show/Hide Object browser
F8 (Auto Hide has to be enabled)

New Query Window
Ctrl + Q

New Query with New Connection
Ctrl + N (Then selecting SQL Server Query template)

Open a .SQL Script file
Ctrl + O

Full Screen
Shift + Alt + Enter

Parse the query
Ctrl + F5

Show/Hide Results Pane
Ctrl + R

Switch between query and results panes
F6

Information about all the objects in the current database
Alt + F1

Posted by | Filed Under SQL