When a developer have to select the row from the table every day frequently to see what are the various kinds of data it contains, Then it is very unwieldy for developers to write code continously.

Suppose you run the following command frequently.

SELECT TOP 1 * FROM TableName

We use SQL Server Management Studio Shortcut  to perform the above code frequently.

Here, I will show you that there is a Query shortcut way to bind the query with keyboard shortcut keys.

Configuring SSMS shortcut.

  • Go to SSMS Menu-> Tools-> Options

  • Select Environment from left panel
  • Keyboard-> Query Shortcuts.

Now on the right side click on the preferred shortcut (in this case I am selecting CTRL + 4) and now in the column of the Stored Procedure type following statement

SELECT TOP 1 * FROM 
Clipboard02.png

Note: I have not mentioned the name of the table. I will SELECT the name of the table later.

Now, select any preferred table name and type CTRL + 3.

You will notice that the query will return desired result.