Post reply

Keyboard shortcut to select top 1000

  • May 7, 2015 at 6:44 pm

    #318077

    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!

  • May 15, 2015 at 12:32 pm

    #1798301

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

    if possible can you share the screenshots as well.

  • May 15, 2015 at 1:22 pm

    #1798321

    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!

  • May 15, 2015 at 1:35 pm

    #1798324

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

  • May 15, 2015 at 1:37 pm

    #1798326

    No problemo, glad to be of help!!

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

  • May 22, 2015 at 8:02 am

    #1800008

    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 😀

  • May 27, 2015 at 8:31 am

    #1800957

    Thanks for the script.

  • December 7, 2016 at 4:39 am

    #1916464

    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

  • December 7, 2016 at 6:55 am

    #1916501

    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