Microsoft® SQL Server™ 2000 SQL Query Analyzer is a graphical tool that allows you to: Create queries and other SQL scripts and execute them against SQL Server databases. (Query window) Quickly create commonly used database objects from predefined scripts.
|
Shortcut |
Command |
|
|
CTRL-SHFT-F2 |
Bookmarks: Clear all bookmarks. |
|
|
CTRL+F2 |
Bookmarks: Insert or remove a bookmark (toggle). |
|
|
F2 |
Bookmarks: Move to next bookmark. |
|
|
SHFT+F2 |
Bookmarks: Move to previous bookmark. |
|
|
ALT+BREAK |
Cancel a query. |
|
|
CTRL+O |
Connections: Connect. |
|
|
CTRL+F4 |
Connections: Disconnect. |
|
|
CTRL+F4 |
Connections: Disconnect and close child window. |
|
|
ALT+F1 |
Database object information. |
|
|
CTRL+SHFT+DEL |
Editing: Clear the active Editor pane. |
|
|
CTRL+SHFT+C |
Editing: Comment out code. |
|
|
CTRL+C |
Editing: Copy. You can also use CTRL+INSERT. |
|
|
CTRL+X |
Editing: Cut. You can also use SHFT+DEL. |
|
|
SHFT+TAB |
Editing: Decrease indent. |
|
|
CTRL+DEL |
Editing: Delete through the end of a line in the
Editor pane. |
|
|
CTRL+F |
Editing: Find. |
|
|
CTRL+G |
Editing: Go to a line number. |
|
|
TAB |
Editing: Increase indent. |
|
|
CTRL+SHFT+L |
Editing: Make selection lowercase. |
|
|
CTRL+SHFT+U |
Editing: Make selection uppercase. |
|
|
CTRL+V |
Editing: Paste. You can also use SHFT+INSERT. |
|
|
CTRL+SHFT+R |
Editing: Remove comments. |
|
|
F3 |
Editing: Repeat last search or find next. |
|
|
CTRL+H |
Editing: Replace. |
|
|
CTRL+A |
Editing: Select all. |
|
|
CTRL+Z |
Editing: Undo. |
|
|
F5 |
Execute a query. You can also use CTRL+E (for backward
compatibility). |
|
|
F1 |
Help for SQL Query Analyzer. |
|
|
SHFT+F1 |
Help for the selected Transact-SQL statement. |
|
|
F6 |
Navigation: Switch between query and result panes. |
|
|
Shft+F6 |
Navigation: Switch panes. |
|
|
CTRL+W |
Navigation: 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 |
Print. |
|
|
CTRL+D |
Results: Display results in grid format. |
|
|
CTRL+T |
Results: Display results in text format. |
|
|
CTRL+B |
Results: Move the splitter. |
|
|
CTRL+SHFT+F |
Results: Save results to file. |
|
|
CTRL+R |
Results: Show Results pane (toggle). |
|
|
CTRL+S |
Save. |
|
|
CTRL+SHFT+INSERT |
Templates: Insert a template. |
|
|
CTRL+SHFT+M |
Templates: Replace template parameters. |
|
|
CTRL+L |
Tuning: Display estimated execution plan. |
|
|
CTRL+K |
Tuning: Display execution plan (toggle ON/OFF). |
|
|
CTRL+I |
Tuning: Index Tuning Wizard. |
|
|
CTRL+SHFT+S |
Tuning: Show client statistics |
|
|
CTRL+SHFT+T |
Tuning: Show server trace. |
|
|
CTRL+U |
Use database. |
|
No comments: