Below a selection of shortcuts in MS SQL Server Management Studio version 2012.


Description  Shortcut
Open a new query. Ctrl. + N 
Execute a single query in an sql document. Select the rows of interest and hit F5 to execute.
Close a selected document. Ctrl. + F4
Open an existing file. Ctrl. + O