<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ken Simmons
»
Include Column Headers From SSMS
19 posts, Page 2 of 2
««
1
2
Include Column Headers From SSMS
Rate Topic
Display Mode
Topic Options
Author
Message
shashi kant
shashi kant
Posted Friday, June 13, 2008 8:50 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:45 AM
Points: 159,
Visits: 457
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
Russel Bell
Russel Bell
Posted Friday, June 13, 2008 9:11 AM
Grasshopper
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
KenSimmons
KenSimmons
Posted Friday, June 13, 2008 10:02 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 09, 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
Jacob Bennett
Jacob Bennett
Posted Friday, June 13, 2008 12:09 PM
Old Hand
Group: General Forum Members
Last Login: Monday, October 15, 2012 3:15 PM
Points: 328,
Visits: 182
Great tips thanks. I never knew that option existed.
Post #516946
Alan Vogan
Alan Vogan
Posted Friday, June 13, 2008 12:44 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:44 AM
Points: 1,079,
Visits: 513
WooHoo!!!
Post #516968
Marianne L Collins
Marianne L Collins
Posted Friday, June 13, 2008 1:37 PM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:13 AM
Points: 227,
Visits: 738
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
Kangana Beri
Kangana Beri
Posted Friday, June 13, 2008 1:45 PM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 3:04 PM
Points: 839,
Visits: 938
Thanks for the great tip!!!
Post #517026
NJahncke
NJahncke
Posted Friday, June 13, 2008 2:33 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, February 04, 2013 9:26 AM
Points: 48,
Visits: 78
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
phased3
phased3
Posted Tuesday, October 13, 2009 5:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 17, 2012 5:14 AM
Points: 3,
Visits: 19
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 »
19 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
