SQL Server Management Studio 2012 keyboard shortcuts (RPM)

Keyboard shortcuts are common, both for DBAs and developer, and the keyboard is much faster than the mouse, but SQL Server 2012 makes a lot of changes to the shortcut keys in SSMS (SQL Server Management Studio). In particular, I used some of the keys, bring me a lot of trouble.

My most commonly used Ctrl+e (the selected part of running the Query Editor), CTRL+L (show estimated execution plan), ctrl+m (including the actual execution plan in the query output) and ctrl+r (show or hide the query Results pane) are not available, it's depressing. Fortunately, SSMs provides a way to customize shortcut keys. Here's how it works:

Press alt+t, then type C, and then type K to open the dialog box that sets the shortcut key. The shortcut keys for SQL Server 2012 are defined in http://msdn.microsoft.com/zh-cn/library/ms174205 (v=sql.110). aspx to be found. Note It is not yet a RTM version and may be updated later.

In the dialog box, under Show command contains, enter plan in the input box, You can find the Query.displayestimatedexecutionplan (show estimated execution plan) and Query.includeactualexecutionplan (include the actual execution plan in the query output). Select Query.displayestimatedexecutionplan, the following "new shortcut key for" select SQL Query Editor; in the input box under "Press shortcut Key", press CTRL and L (do not enter CTRL these letters, regardless of the use: ), and then press the Assign button.

The selected part of running the Query Editor (query.execute) can be valid in several Windows such as SQL Query Editor, XMLA Script Editor, you can assign shortcut keys individually, or you can specify shortcut keys in the text editor. Can be valid for multiple editor at the same time. The display or Hide Query Results pane (Window.showresultspane) can also be set.

Note that after you set these shortcuts, some of the combinations of shortcut keys that are defined by SQL Server 2012, such as Ctrl+e, will be overwritten. To adapt to the new shortcut keys, or continue to use the old shortcuts, please choose.

Too lazy to manually set up, you can import this definition file. Press alt+t, and then type I to start the Import and Export Settings Wizard.

Http://blog.sina.com.cn/s/blog_624f972301013cj4.html

SQL Server Management Studio 2012 keyboard shortcuts (RPM)