Keyboard shortcut to select top 1000

  • Comments posted to this topic are about the item Keyboard shortcut to select top 1000

    The pain of Discipline is far better than the pain of Regret!

  • I tried this but some how its not working for me am I missing something

    if possible can you share the screenshots as well.

  • Sure. SO here is a screen shot of the procedure as a keyboard short cut and a snap shot of the table highlighted, now hit Ctrl + 6 to display or select top 100 *.

    The pain of Discipline is far better than the pain of Regret!

  • Thanks Arnold:-) I got it !! I was confused before and highlighting in object explorer

  • No problemo, glad to be of help!!

    The pain of Discipline is far better than the pain of Regret!

  • I hate to point it out because the OP has done a lot of nice SP work for this and has a GREAT documentation header, albeit some very minor typos.

    but you can simply put "SELECT TOP 1000 * FROM " in the shortcut panel and it works just fine 😀

  • Thanks for the script.

  • wordracr (5/22/2015)


    I hate to point it out because the OP has done a lot of nice SP work for this and has a GREAT documentation header, albeit some very minor typos.

    but you can simply put "SELECT TOP 1000 * FROM " in the shortcut panel and it works just fine 😀

    or just right click on the table/view in Object Explorer and click on Select Top 100 Rows

  • Old tip but always appropriate, thanks again.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply