Microsoft SQL Server Microsoft SQL Server Management Studio Shortcut Keys Custom keyboard shortcuts

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Example

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.



Got any Microsoft SQL Server Question?