Create Query Shortcuts in SQL Server Management Studio

Introduction

Generally, we are checking your queries or debugging previously written queries and in between we have to check other things. For that, we can take the help of shortcuts. This shortcut will speed up your working.

Using the Code

We can create shortcuts for commonly used queries in SSMS. Some of the shortcuts are predefined, like "Alt + F1" will execute "sp_help" and "Ctrl + 1" will execute "sp_who" which we are using in routines. You can create new shortcuts for your own queries to speedup.

To create a own shortcut, open SSMS and go to : Tools > Options > Environment > Keyboard > Query Shortcuts

For example, we can create a shortcut for:

//
// "Ctrl + 3 " : SELECT * FROM (single space after from keyword)
//

Now just write a name of table in new query and press "ctrl + 3" and the query will be executed.

Now, working in any query or stored procedure, this will help you a lot to check the data in the specific table or count of table.

Below are some examples of shortcut.

• "ctrl + 3" for all the records in specific table
• "ctrl + 4" for total count of specific table
• "ctrl + 5" to get text of store procedure

Points of Interest

You have still more shortcuts to create by yourself. Now make your own shortcut and speedup your working.