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 123»»»

SSMS Results Expand / Collapse
Author
Message
Posted Friday, April 18, 2014 12:09 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
Comments posted to this topic are about the item SSMS Results






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1562915
Posted Friday, April 18, 2014 12:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
Too easy
Have a nice Easter weekend, and don't eat too much chocolate!




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 #1562916
Posted Friday, April 18, 2014 12:11 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 706, Visits: 1,264
Koen Verbeeck (4/18/2014)
Too easy
Have a nice Easter weekend, and don't eat too much chocolate!

+1000
Post #1562917
Posted Friday, April 18, 2014 1:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:23 AM
Points: 2,509, Visits: 2,386
When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.
Post #1562924
Posted Friday, April 18, 2014 1:17 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 11:45 PM
Points: 562, Visits: 887
twin.devil (4/18/2014)
Koen Verbeeck (4/18/2014)
Too easy
Have a nice Easter weekend, and don't eat too much chocolate!

+1000


hey,this is not done. I got only +1


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1562926
Posted Friday, April 18, 2014 1:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
Carlo Romagnano (4/18/2014)
When results come out in text, you can search for a string (ctrl+f), instead, in grid mode you can not search in the results.


You can copy paste the grid easily to Excel though.
And with Text mode it's not easy to see how many rows were returned.

Another advantage of text is that is usually returns results much faster than the grid.
And it's better to test dynamic SQL




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 #1562937
Posted Friday, April 18, 2014 2:05 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:49 AM
Points: 923, Visits: 2,108
Koen Verbeeck (4/18/2014)
Too easy
Have a nice Easter weekend, and don't eat too much chocolate!

awww... Okay I will stop now. (...just one last piece...)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1562939
Posted Friday, April 18, 2014 2:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:23 AM
Points: 2,509, Visits: 2,386
In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt
Post #1562940
Posted Friday, April 18, 2014 2:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:51 PM
Points: 13,639, Visits: 10,534
Carlo Romagnano (4/18/2014)
In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt


This QotD has become quite the "fun facts" collection about SSMS query results




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 #1562941
Posted Friday, April 18, 2014 3:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:27 AM
Points: 1,855, Visits: 570
Show hide query results pane shortcut is changed in SQL Server 2012 version.
If the settings are imported from SQL Server 2008 settings, then it remain same CTRL +R. Otherwise CTRL+SHIFT+ALT+R will show hide the query result pane. (Show and hide the query result pane, not only to show)

But when I look into the reference link, it says

Show or hide the query results pane -> CTRL+R
Show the query results pane -> CTRL+SHIFT+ALT+R

What it means?


-----------------
Gobikannan
Post #1562943
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse