Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Getting the grid back Expand / Collapse
Author
Message
Posted Thursday, May 15, 2014 9:26 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:15 PM
Points: 31,210, Visits: 15,654
Comments posted to this topic are about the item Getting the grid back






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1571587
Posted Thursday, May 15, 2014 10:07 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:05 PM
Points: 3,044, Visits: 2,649
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...".



Post #1571595
Posted Thursday, May 15, 2014 11:31 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 5:51 PM
Points: 17,845, Visits: 15,797
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
Post #1571603
Posted Friday, May 16, 2014 12:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1571608
Posted Friday, May 16, 2014 12:24 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 8:16 AM
Points: 793, Visits: 1,461
Tried on 2012, Ctrl+D toggles between text and grid output, Ctrl+Shift+D does nothing with me.

Lost one valuable point...
Post #1571610
Posted Friday, May 16, 2014 12:40 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 789, Visits: 1,404
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,


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

Post #1571615
Posted Friday, May 16, 2014 12:46 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 3,143, Visits: 3,419
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
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
Post #1571616
Posted Friday, May 16, 2014 12:49 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:17 AM
Points: 3,017, Visits: 3,105
CTRL+T - for text
CTRL+D - for grid
in my ssms 2008r2, 2012 and 2014.




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1571619
Posted Friday, May 16, 2014 12:50 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 4:52 AM
Points: 3,300, Visits: 1,315
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.
Post #1571620
Posted Friday, May 16, 2014 12:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:48 PM
Points: 822, Visits: 1,426
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,


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
Post #1571622
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse