Getting the grid back

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

  • 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...".

  • 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

  • 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

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

    Lost one valuable point...

  • 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 😛

  • 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 question
    There 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

  • CTRL+T - for text

    CTRL+D - for grid

    in my ssms 2008r2, 2012 and 2014.

    Igor Micev,My blog: www.igormicev.com

  • 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.

  • 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 😛

  • 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

  • Easy one, thanks.

  • 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

  • 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.

  • 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 43 total)

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