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.