Keyboard key to Toggle between query and results pane

  • Hardy21

    SSCrazy Eights

    Points: 9708

    Comments posted to this topic are about the item Keyboard key to Toggle between query and results pane

    Thanks

  • Carlo Romagnano

    SSC-Insane

    Points: 21965

    Also SHIFT+F6. These hot keys are windows standard.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • free_mascot

    One Orange Chip

    Points: 27168

    Good One!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Good one, thank you for the post.

    Agreed F6 and SHIFT+F6 - both works. But they are not the same.

    F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]

    SHIFT+F6 in SSMS is "move to the previous pane"

    Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Carlo Romagnano

    SSC-Insane

    Points: 21965

    Raghavendra Mudugal (5/30/2014)


    Good one, thank you for the post.

    Agreed F6 and SHIFT+F6 - both works. But they are not the same.

    F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]

    SHIFT+F6 in SSMS is "move to the previous pane"

    Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

    Of course, they just differ in direction (next/previous)! But if you are in grid mode with ONE F6 go to result pane, the same with TWO SHIFT+F6 (first goes to the message pane and the second to the result pane).

  • rhythmk

    SSCertifiable

    Points: 7162

    Thanks Hardik for question.

    However with the introduction of new keyboard having fn key in place.Microsoft should also change their doumentation.

    As here it would be (fn + f6) key would be the answer.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • crmitchell

    SSCarpal Tunnel

    Points: 4557

    Strictly speaking f6 isn't a toggle

    It will cycle through all open panes not just those two and if you don't have the results pane visible it won't show it.

    You could argue that ctrl-R would better fit as an answer as that is a toggle and will show/hide the results pane.

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    Easy one like for Friday 🙂

    Igor Micev,
    My blog: www.igormicev.com

  • Ed Wagner

    SSC Guru

    Points: 286982

  • NerdherderII

    SSC Journeyman

    Points: 85

    I would agree, ctl + R is the correct answer.

  • SQLRNNR

    SSC Guru

    Points: 281243

    rhythmk (5/30/2014)


    Thanks Hardik for question.

    However with the introduction of new keyboard having fn key in place.Microsoft should also change their documentation.

    As here it would be (fn + f6) key would be the answer.

    +10

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the question.

    The options of fn+f6 and shft+f6 are great for toggling between the query, messages, and results tabs.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RLilj33

    SSCrazy

    Points: 2153

    Thanks Hardik. Nice question.

  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 20 total)

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