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

Include Column Headers From SSMS Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 9:51 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 9, 2013 8:07 AM
Points: 1,220, Visits: 2,614
Comments posted to this topic are about the item Include Column Headers From SSMS

Ken Simmons
http://twitter.com/KenSimmons
Post #516389
Posted Friday, June 13, 2008 2:57 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: Thursday, September 4, 2014 1:27 AM
Points: 841, Visits: 331
After switching to SSMS I worked my way through all the options and found this tip a short time ago. But the only thing I really miss is that in QA I got a message for each Insert/Update/Delete of how many rows are/were affected.

I couldn't find an option or configuration help how to get this back. Seems to be lost in SSMS.
Anyone an idea?
Post #516485
Posted Friday, June 13, 2008 3:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:01 AM
Points: 29, Visits: 541
Thank you for this Top Tip. It's been secretly annoying me for ages not taking the column headers across.
Nice one :)
Post #516513
Posted Friday, June 13, 2008 6:42 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: Wednesday, June 20, 2012 5:02 AM
Points: 530, Visits: 945
This doesn't work for me. I have SS2005, but I'm still not getting those pesky headers...
Post #516623
Posted Friday, June 13, 2008 7:40 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 35,267, Visits: 31,760
Which service pack are you running?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #516689
Posted Friday, June 13, 2008 7:53 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 12:52 PM
Points: 612, Visits: 975
Thank you, thank you, THANK YOU!
We run a lot of ad-hoc queries for a group of users, and send the results back in Excel spreadsheets - this help immensely.



Here there be dragons...,

Steph Brown
Post #516711
Posted Friday, June 13, 2008 7:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 21, 2013 8:42 AM
Points: 13, Visits: 264
I have found that column headers behave differently when writing a query from scratch (new query) versus opening a table. When I "open" a table with a right click, I cannot get column headers even with the option set. When I use "New query" the setting works.

When opening a table the Query Designer toolbar is active, enabling "Change Type", "Verify SQL Syntax", etc. In this mode the column headers do not copy even when the option is set correctly.

When using "New Query", the Query Designer toolbar is not active and the column header copies when the option is set.

Another observation. In SQL 2000, the grid lines would copy when pasting to Outlook. Now I have to paste into Excel and turn on grid lines to get lines when pasting. Anyone found a better way? ;)
Post #516721
Posted Friday, June 13, 2008 8:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 25, 2014 12:51 PM
Points: 5, Visits: 87
How do you setup this functionality in Enterprise Manager?


Post #516777
Posted Friday, June 13, 2008 8:49 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,375, Visits: 1,391
Thanks for a good tip.......:)


Post #516778
Posted Friday, June 13, 2008 8:50 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: Wednesday, June 20, 2012 5:02 AM
Points: 530, Visits: 945
I'm using SP2 and my screen has an extra tick box, 'Quote strings contain list separators when saving .csv results' under Results to Grid.
Anyway, it now works! Thanks.
Post #516779
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse