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 Friday, June 13, 2008 8:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:41 AM
Points: 162, Visits: 509
HI,

There is other alternative available for this header option
You can get this option by selecting these options


Query -> Query Options ->Results -> and then select the option of Include column headers when copying or saving the results

Regards
Shashi Kant Chauhan

Post #516781
Posted Friday, June 13, 2008 9:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 21, 2013 8:42 AM
Points: 13, Visits: 264
seiiv (6/13/2008)
How do you setup this functionality in Enterprise Manager?


In Enterprise Manager I have not been able to copy column headers in Query Analyzer. Instead I create and run the query in the "View Designer", then use shift and arrow keys to highlight all the columns, then copy and paste. Do not need to save as a view, just use its query builder.
Post #516814
Posted Friday, June 13, 2008 10:02 AM


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,221, Visits: 2,614
In Enterprise Manager you have to highlight the column header by clicking the cell header.

Ken Simmons
http://twitter.com/KenSimmons
Post #516860
Posted Friday, June 13, 2008 12:09 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, October 21, 2013 7:11 AM
Points: 328, Visits: 188
Great tips thanks. I never knew that option existed.
Post #516946
Posted Friday, June 13, 2008 12:44 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 1,082, Visits: 540
WooHoo!!!
Post #516968
Posted Friday, June 13, 2008 1:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:58 PM
Points: 227, Visits: 748
shashi kant (6/13/2008)
HI,

There is other alternative available for this header option
You can get this option by selecting these options


Query -> Query Options ->Results -> and then select the option of Include column headers when copying or saving the results

Regards
Shashi Kant Chauhan



FYI - I believe that only sets the options for that particular query. You need to use the Tools->Options route to enable the headers for all queries going forward.

-Marianne
Post #517017
Posted Friday, June 13, 2008 1:45 PM
SSC Eights!

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

Group: General Forum Members
Last Login: Friday, August 8, 2014 6:08 PM
Points: 872, Visits: 953
Thanks for the great tip!!!
Post #517026
Posted Friday, June 13, 2008 2:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 17, 2014 6:17 AM
Points: 48, Visits: 86
Hey thanks for posting this! I've been dealing with the inconvenience of writing out the column names by hand for a long time now lol...
Post #517062
Posted Tuesday, October 13, 2009 5:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:50 PM
Points: 4, Visits: 20
Great Tip.
Tools > Options
+ Query Results
+ SQL Server
Select 'Results to Grid'
Check ' Include column headers when copying or saving results'
Post #802070
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse