Sql-server – How to add keyboard shortcuts in SSMS 2012 to run a specific query

keyboard shortcutssql-server-2012ssms

How do I add keyboard shortcuts in SSMS 2012 to select all the data from table?

In SSMS 2008 we could assign a shortcut in the following way:

TOOLS–>OPTIONS–>ENVIRONMENT–>KEYBOARD—>CTRL+3–>Select * from

This doesn't appear to be possible in SSMS 2012.

Best Answer

The option is still there (although this is from SQL Server 2014):

enter image description here

You don't normally have to restart SSMS, just open a new query window.

Related Question