Microsoft SQL Server Custom keyboard shortcuts


Go to Tools -> Options. Go to Environment -> Keyboard -> Query Shortcuts

On the right side you can see some shortcuts which are by default in SSMS. Now if you need to add a new one, just click on any column under Stored Procedure column.

enter image description here

Click OK. Now please go to a query window and select the stored procedure then press CTRL+3, it will show the stored procedure result.

enter image description here

Now if you need to select all the records from a table when you select the table and press CTRL+5(You can select any key). You can make the shortcut as follows.

enter image description here

Now go ahead and select the table name from the query window and press CTRL+4(The key we selected), it will give you the result.