Getting the grid back

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 721105

    Comments posted to this topic are about the item Getting the grid back

  • happycat59

    One Orange Chip

    Points: 29308

    Yes, the documentation does say CTRL + Shift + D however, as far as I can tell, this does nothing when using SSMS 2012. CTRL + D does change the output to grid - when the query is next executed. Also, if you go to the menu "Query-->Results To" it shows you the keyboard shortcut for "Results to Grid" which is "Ctrl+D"

    When I use CTRL + Shift + D on its own in SSMS 2014, nothing happens because SSMS is waiting for the second key of a chord (in the status line at the bottom of the screen you get the message "(Ctrl+Shift+D) was pressed. Waiting for second key of chord...".

  • SQLRNNR

    SSC Guru

    Points: 281252

    happycat59 (5/15/2014)


    Yes, the documentation does say CTRL + Shift + D however, as far as I can tell, this does nothing when using SSMS 2012. CTRL + D does change the output to grid - when the query is next executed. Also, if you go to the menu "Query-->Results To" it shows you the keyboard shortcut for "Results to Grid" which is "Ctrl+D"

    When I use CTRL + Shift + D on its own in SSMS 2014, nothing happens because SSMS is waiting for the second key of a chord (in the status line at the bottom of the screen you get the message "(Ctrl+Shift+D) was pressed. Waiting for second key of chord...".

    +1

    I believe there is a problem with the documentation and in this case the question was meant for 2014 instead of 2012 as the question states. I answered for 2012 and discovered I was wrong though CTRL+D is accurate in 2012 and does work.

    In SSMS 2014, if I use CTRL+D, it will toggle me from text output to grid output. CTRL+Shift+D does nothing for me. I think this is another one of those opportunities for a connect item with MS.

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

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

  • Louis Hillebrand

    SSCarpal Tunnel

    Points: 4254

    Tried on 2012, Ctrl+D toggles between text and grid output, Ctrl+Shift+D does nothing with me.

    Lost one valuable point...

  • twin.devil

    SSC-Insane

    Points: 22208

    Koen Verbeeck (5/16/2014)


    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

    +1, :hehe:

    by the way nice question STEVE, its our fault not to understand the significance of "NOT" keyword 😛

  • Stuart Davies

    SSCoach

    Points: 18878

    Koen Verbeeck (5/16/2014)


    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

    +1

    I always thought (and have found it to work in all version of SSMS I've used) CTRL+R toggles showing / hiding the results.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    CTRL+T - for text

    CTRL+D - for grid

    in my ssms 2008r2, 2012 and 2014.

    Igor Micev,
    My blog: www.igormicev.com

  • Mighty

    SSCrazy Eights

    Points: 8853

    Koen Verbeeck (5/16/2014)


    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

    I also thought the wording was strange, in fact I thought the "not" was there by accident. Which was supported by the title of the question "Getting the grid back". So I choose for the least wrong option.

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    twin.devil (5/16/2014)


    Koen Verbeeck (5/16/2014)


    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

    +1, :hehe:

    by the way nice question STEVE, its our fault not to understand the significance of "NOT" keyword 😛

    +1

    nice question STEVE, its our fault not to understand the significance of "NOT" keyword 😛

  • Ford Fairlane

    SSCertifiable

    Points: 7664

    Koen Verbeeck (5/16/2014)


    Am I the only one who thought the question was worded a bit strange?

    However you would not like to get the results back in a grid

    Anyway, as stated above, the "correct" answer is clearly incorrect.

    +1

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Richard Warr

    SSCertifiable

    Points: 6957

    Easy one, thanks.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Richard Warr (5/16/2014)


    Easy one, thanks.

    You have the only working copy of SQL Server 2012 where CTRL+SHIFT+D actually does something?

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

  • SQLDoubleG

    Hall of Fame

    Points: 3090

    If you have results to text and you WOULD NOT want them back to grid, the best answer is DO NOTHING... and it will stay as is.

    Definitely, that negative did not help, and I agree with others as BOL is wrong... tool tip text over the button itself stays Ctrl+D.

  • paul.goldstraw

    SSCrazy

    Points: 2626

    Koen Verbeeck (5/16/2014)


    Richard Warr (5/16/2014)


    Easy one, thanks.

    You have the only working copy of SQL Server 2012 where CTRL+SHIFT+D actually does something?

    Maybe he's running SQL Server 2012 QOTD Edition? 😉

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

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