SSMS: Useful custom keyboard shortcut

I’m sure you already know that you can configure custom keyboard shortcuts in SQL Server Management Studio. Here’s a shortcut that I find really handy, and one that I use frequently.

SELECT TOP query editor shortcut

SQL Server Management Studio automatically appends any text you select in the editor to the command text of the keyboard shortcut, so if you create a shortcut like the one above, you can use this code to quickly retrieve a snapshot of a table or view, simply by selecting the name of it in the editor and pressing Ctrl+F1.

Let me hear your thoughts!

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s