SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video

SQL SERVER - Shortcut to SELECT Single Row from Table - SQL in Sixty Seconds #046 - Video 60x60

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:

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)

, , ,
Previous Post
SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
Next Post
SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013

Related Posts

3 Comments. Leave new

  • Sanjay Monpara
    March 13, 2013 12:02 pm

    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

    Reply
  • 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?

    Reply

Leave a Reply

Menu