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 @ 8:55 AM
Points: 33,267, Visits: 15,437
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:07 PM
Points: 2,989, Visits: 2,588
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:33 AM
Points: 21,753, Visits: 15,450
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1571603
Posted Friday, May 16, 2014 12:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 13,735, Visits: 10,703
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:53 AM
Points: 751, Visits: 1,217
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 @ 4:13 AM
Points: 747, 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.


+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 @ 3:20 AM
Points: 3,086, Visits: 3,283
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:31 AM
Points: 2,956, Visits: 2,977
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: Yesterday @ 5:50 AM
Points: 3,263, Visits: 1,286
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: Monday, September 15, 2014 3:14 AM
Points: 805, Visits: 1,401
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