Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting the grid back


Getting the grid back

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36176 Visits: 18751
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
My Blog: www.voiceofthedba.com
happycat59
happycat59
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3565 Visits: 3107
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
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21093 Visits: 18259
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

Koen Verbeeck
Koen Verbeeck
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16465 Visits: 13207
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Louis Hillebrand
Louis Hillebrand
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1529 Visits: 3208
Tried on 2012, Ctrl+D toggles between text and grid output, Ctrl+Shift+D does nothing with me.

Lost one valuable point...
twin.devil
twin.devil
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1378 Visits: 2597
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 :-P
Stuart Davies
Stuart Davies
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4491 Visits: 4549
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
Igor Micev
Igor Micev
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4174 Visits: 4849
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
Mighty
Mighty
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4177 Visits: 1648
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
pmadhavapeddi22
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1291 Visits: 1865
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 :-P



+1

nice question STEVE, its our fault not to understand the significance of "NOT" keyword :-P
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search