Wednesday, November 24, 2010

SQL Server Tips (Keyboard Short cuts)



TaskShortcuts
Create a New FileCTRL+N
Toggle full screen modeSHIFT+ALT+ENTER
Toggle Result PaneCTRL+R
Comment Selected TextCTRL+K, CTRL+C
Uncomment the selected textCTRL+K, CTRL + U
Make the selected text upper caseCTRL+SHIFT+U
Make the selected text lower caseCTRL+SHIFT+L
Toggle between query and results paneF6
Display Object ExplorerF8
Output results in text formatCTRL+D
Output results in a gridCTRL+T
Cancel the executing queryALT+BREAK
Display the estimated execution planCTRL+L
Display the Replace dialog boxCTRL+H
Start incremental searchCTRL+I
Display the Find dialog boxCTRL+F
Find the next occurrence of the previous search textF3
Next bookmarkCTRL+K, CTRL+N
Execute QueryF5
Parse QueryCTRL+F5
Set or remove a bookmark at the current lineCTRL+K, CTRL+K
Previous bookmarkCTRL+K, CTRL+P
Clear bookmarksCTRL+K, CTRL+L
Go To a Line NumberCTRL+G
Display Context Menu(What is done through right click)SHIFT+F10
Change Database(It will focus on available datasoursec dropdown , you can type the database name or you can navigate through arrow buttons)CTRL+U

No comments:

Post a Comment