Home             About Us             Sign Guest Book             Contact Us             Subscribe              RSS  
Articles
Tools
Code Snippets
Links
Tips & Tricks
FAQ
Resources
Articles
Code Snippets
Links
FAQ
Resources

Saravana Kumar
Vinod Kumar

Click on the image to subscribe to our Monthly Newsletter.


Click here for Archives

Developing Infopath Solutions (Only for My Tech.Ed Participants)
Kamaljit Bath, Lead Program Manager, Microsoft Corporation
Date: 9/18/2003

SQL Server Shortcut keys enlisted ...

Query Analyzer is a great tool to have and here are a list of all shortcut keys you can use to speedup your keyboard capabilities to use Query Analyzer.

Bookmarks: Clear all bookmarks.

CTRL-SHIFT-F2

Bookmarks: Insert or remove a bookmark (toggle).

CTRL+F2

Bookmarks: Move to next bookmark.

F2

Bookmarks: Move to previous bookmark.

SHIFT+F2

Cancel a query.

ALT+BREAK

Connections: Connect.

CTRL+O

Connections: Disconnect.

CTRL+F4

Connections: Disconnect and close child window.

CTRL+F4

Database object information.

ALT+F1

Editing: Clear the active Editor pane.

CTRL+SHIFT+ DEL

Editing: Comment out code.

CTRL+SHIFT+C

Editing: Copy. You can also use CTRL+INSERT.

CTRL+C

Editing: Cut. You can also use SHIFT+DEL.

CTRL+X

Editing: Decrease indent.

SHIFT+TAB

Editing: Delete through the end of a line in the Editor pane.

CTRL+DEL

Editing: Find.

CTRL+F

Editing: Go to a line number.

CTRL+G

Editing: Increase indent.

TAB

Editing: Make selection lowercase.

CTRL+SHIFT+L

Editing: Make selection uppercase.

CTRL+SHIFT+U

Editing: Paste. You can also use SHIFT+INSERT.

CTRL+V

Editing: Remove comments.

CTRL+SHIFT+R

Editing: Repeat last search or find next.

F3

Editing: Replace.

CTRL+H

Editing: Select all.

CTRL+A

Editing: Undo.

CTRL+Z

Execute a query. You can also use CTRL+E (for backward compatibility).

F5

Help for SQL Query Analyzer.

F1

Help for the selected Transact-SQL statement.

SHIFT+F1

Navigation: Switch between query and result panes.

F6

Navigation: Switch panes.

Shift+F6

Navigation: Window Selector.

CTRL+W

New Query window.

CTRL+N

Object Browser (show/hide).

F8

Object Search.

F4

Parse the query and check syntax.

CTRL+F5

Print.

CTRL+P

Results: Display results in grid format.

CTRL+D

Results: Display results in text format.

CTRL+T

Results: Move the splitter.

CTRL+B

Results: Save results to file.

CTRL+SHIFT+F

Results: Show Results pane (toggle).

CTRL+R

Save.

CTRL+S

Templates: Insert a template.

CTRL+SHIFT+INSERT

Templates: Replace template parameters.

CTRL+SHIFT+M

Tuning: Display estimated execution plan.

CTRL+L

Tuning: Display execution plan (toggle ON/OFF).

CTRL+K

Tuning: Index Tuning Wizard.

CTRL+I

Tuning: Show client statistics

CTRL+SHIFT+S

Tuning: Show server trace.

CTRL+SHIFT+T

Use database.

CTRL+U

So lets get started ....

Comment about this article
Free Hit Counters
Free Hit Counters