Earlier I have blogged about the same subject and in very short time I received lots of good comments about this blog post as well lots of email from users who faced issues to make this work. Thought, the instructions are very simple in the blog post, every user read it differently and they have a different interpretation. I finally decided to do convert the same blog post in the video. I hope now it will be much easier to understand it.
If you watch any SQL Server Developer, you will notice one particular task them doing every day frequently. It is they select the row from the table to see what are the various kinds of data it contains. It is very cumbersome for developers to continuously write following code to retrieve a single row to see what the table contains. There is a shortcut how we can make our life easier if we use SQL Server Management Studio Shortcut. In this quick video we will see how we can create a shortcut which will select a single row from a table.
Let us see the same concept in following SQL in Sixty Seconds Video:
[youtube=http://www.youtube.com/watch?v=Jc7KpgCHNa4]
Related Tips in SQL in Sixty Seconds:
What would you like to see in the next SQL in Sixty Seconds video?
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
3 Comments. Leave new
Its very useful,
I am using this feature for 3 task
Ctrl+3 : SELECT TOP 1 * FROM (for single row)
Ctrl+4 : SELECT COUNT(*) COUNTS FROM (for count)
Ctrl+5 : SELECT * FROM (for all rows)
Is there any more task for which we can use this feature, plz share.
Thanks Pinal
Strangely this does not work, however the canned shortcuts (sp_who, sp_lock, sp_help) all work fine. ‘SELECT TOP 1 * FROM ‘ on SQL 2012. Any ideas?
Do you see any error or any message at the bottom of SSMS?