SQL Rob

SQL Server and other database technologies

Reference

SSMS Shortcuts:
New Query Window: ctrl + N
Toggle between open query windows: ctrl + F6
Toggle between tabs on results window: F6
Close query window: ctrl + F4
Results Pane on/off: ctrl + R
Object Explorer: F8
Run Query: F5
Stop running query: alt + break
Parse Query: ctrl + F5
Save: ctrl + S
Select multiple lines to edit all lines at once – add commas to all lines, etc.: alt + shift + arrow
Change server connection: ctrl + F7
Change database: ctrl + U

Windows Shortcuts:
Shift + F10 – Right click menu
Alt + Up Arrow – Go up a level in File Explorer

Command Line Commands:
cd: Change Directory
cls: Clear Screen
del: Delete Files
dir: List Directory Content
mkdir: Create Directory
move: Move files
netstat: Display Connections
pause: Pause Execution
rd: Remove Directory
xcopy: Copy Files