Please visit my new Web Site https://coderstechzone.com
In most of the time developers need to prepare query for reports. So if we know the shortcuts of query analyzer we can increase operational excellence as well as own productivity. Hope the below list of shortcuts will help us more.
A list of Keyboard Shortcuts in SQL Query Analyzer:
A list of Keyboard Shortcuts in SQL Query Analyzer:
Key | Description | Key | Description |
CTRL-SHIFT-F2 | Clear all bookmarks. | CTRL+F2 | Insert or remove a bookmark (toggle). |
F2 | Move to next bookmark. | SHIFT+F2 | Move to previous bookmark. |
ALT+BREAK | Cancel a query. | CTRL+O | Connect. |
CTRL+F4 | Disconnect. | CTRL+F4 | Disconnect and close child window. |
ALT+F1 | Database object information. | CTRL+SHIFT+DEL | Clear the active Editor pane. |
CTRL+SHIFT+C | Comment out code. | CTRL+C or Ctrl+Insert | Copy |
CTRL+X or Shift+Del | Cut | SHIFT+TAB | Decrease indent. |
CTRL+DEL | Delete through the end of a line in the Editor pane. | CTRL+F | Find. |
CTRL+G | Go to a line number. | TAB | Increase indent. |
CTRL+SHIFT+L | Make selection lowercase. | CTRL+SHIFT+U | Make selection uppercase. |
CTRL+V or Shift+Insert | Paste. | CTRL+SHIFT+R | Remove comments. |
F3 | Repeat last search or find next. | CTRL+H | Replace. |
CTRL+A | Select all. | CTRL+Z | Undo. |
F5 or Ctrl + E | Execute a query. | F1 | Help for Query Analyzer. |
SHIFT+F1 | Help for the selected Transact-SQL statement. | F6 | Switch between query and result panes. |
Shift+F6 | Switch panes. | CTRL+W | Window Selector. |
CTRL+N | New Query window. | F8 | Object Browser (show/hide). |
F4 | Object Search. | CTRL+F5 | Parse the query and check syntax. |
CTRL+P | CTRL+D | Display results in grid format. | |
CTRL+T | Display results in text format. | CTRL+B | Move the splitter. |
CTRL+SHIFT+F | Save results to file. | CTRL+R | Show Results pane (toggle). |
CTRL+SHIFT+M | Replace template parameters. | CTRL+L | Display estimated execution plan. |
CTRL+K | Display execution plan (toggle ON/OFF). | CTRL+I | Index Tuning Wizard. |
CTRL+SHIFT+S | Show client statistics | CTRL+SHIFT+T | Show server trace. |
CTRL+U | Usedatabase |
Ref: http://www.odetocode.com/
0 comments:
I WOULD BE DELIGHTED TO HEAR FROM YOU