SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Ken Simmons / Include Column Headers From SSMS / Latest Posts

RE: Include Column Headers From SSMS

phased3 — Tue, 13 Oct 2009 05:23:18 GMT

Great Tip. Tools > Options + Query Results + SQL Server Select 'Results to Grid'Check ' Include column headers when copying or saving results'

RE: Include Column Headers From SSMS

NJahncke — Fri, 13 Jun 2008 14:33:18 GMT

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...

RE: Include Column Headers From SSMS

Kangana Beri — Fri, 13 Jun 2008 13:45:49 GMT

Thanks for the great tip!!!

RE: Include Column Headers From SSMS

Marianne L Collins — Fri, 13 Jun 2008 13:37:11 GMT

[quote][b]shashi kant (6/13/2008)[/b][hr]HI,There is other alternative available for this header optionYou can get this option by selecting these optionsQuery -> Query Options ->Results -> and then select the option of Include column headers when copying or saving the resultsRegardsShashi Kant Chauhan :cool:[/quote]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

RE: Include Column Headers From SSMS

Alan Vogan — Fri, 13 Jun 2008 12:44:52 GMT

WooHoo!!!:w00t::w00t:

RE: Include Column Headers From SSMS

Jacob Bennett — Fri, 13 Jun 2008 12:09:50 GMT

Great tips thanks. I never knew that option existed.

RE: Include Column Headers From SSMS

KenSimmons — Fri, 13 Jun 2008 10:02:56 GMT

In Enterprise Manager you have to highlight the column header by clicking the cell header.

RE: Include Column Headers From SSMS

Russel Bell — Fri, 13 Jun 2008 09:11:41 GMT

[quote][b]seiiv (6/13/2008)[/b][hr]How do you setup this functionality in Enterprise Manager?[/quote]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. :cool:

RE: Include Column Headers From SSMS

shashi kant — Fri, 13 Jun 2008 08:50:44 GMT

HI,There is other alternative available for this header optionYou can get this option by selecting these optionsQuery -> Query Options ->Results -> and then select the option of Include column headers when copying or saving the resultsRegardsShashi Kant Chauhan :cool:

RE: Include Column Headers From SSMS

Jon Spink — Fri, 13 Jun 2008 08:50:10 GMT

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.

RE: Include Column Headers From SSMS

Anipaul — Fri, 13 Jun 2008 08:49:46 GMT

Thanks for a good tip.......:)

RE: Include Column Headers From SSMS

seiiv — Fri, 13 Jun 2008 08:49:22 GMT

How do you setup this functionality in Enterprise Manager?

RE: Include Column Headers From SSMS

Russel Bell — Fri, 13 Jun 2008 07:59:29 GMT

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? ;)

RE: Include Column Headers From SSMS

Stephanie J Brown — Fri, 13 Jun 2008 07:53:59 GMT

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.

RE: Include Column Headers From SSMS

Jeff Moden — Fri, 13 Jun 2008 07:40:09 GMT

Which service pack are you running?

RE: Include Column Headers From SSMS

Jon Spink — Fri, 13 Jun 2008 06:42:41 GMT

This doesn't work for me. I have SS2005, but I'm still not getting those pesky headers...

RE: Include Column Headers From SSMS

d trotman — Fri, 13 Jun 2008 03:55:53 GMT

Thank you for this Top Tip. It's been secretly annoying me for ages not taking the column headers across.Nice one :)

RE: Include Column Headers From SSMS

Knut Boehnert — Fri, 13 Jun 2008 02:57:39 GMT

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?

Include Column Headers From SSMS

KenSimmons — Thu, 12 Jun 2008 21:51:49 GMT

Comments posted to this topic are about the item [B]Include Column Headers From SSMS[/B]