Copy Column Headers in Query Analyzers in Result Set.
In Query Analyzer go to Menu >> Tools >> Options >> Results
Select Default results Target: Results to Text
Results output format:(*): Tab Delimited
Print column headers(*): Checkbox ON(check)
[youtube=http://www.youtube.com/watch?v=BL5GO-jH3HA]
Reference : Pinal Dave (https://blog.sqlauthority.com)
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
17 Comments. Leave new
It worked Fine!!!! Thanks A lot.
Saludos desde Panama
This worked for me like a charm! I was wondering how to do that without having to manually type the headings in Excel! Thanks!
Thank you a lot!!!
Do we have any other option beside this ?
Reply must be appriciated !
Thanks !
Parmod Bhardwaj
Thank you!
Searched for this option since a long time. Drives you crazy!
regards Florian
This is a great tip!!! I was searcning this very long time. Thanks
thanks a span buddie-it worked wonders for couldnt take the typing no more worse off for large queries
THanks a lot !! I got this site after a lot of effort, the TIP worked just as desired. WOuld recommend this to everyone !!
Excellent info — thank you very much! Mr. Dave, you are the man!!
Thanks alot!!! well i should be knowing that.. but anyways better late than never.
Ah, so that’s how it’s done – good tip, thanks.
Thanks Mr. Dave.
This is coimgn as a real help to me.
Keep up the great work. :-)
a: thanks, I can’t tell you how many times I looked for this, and I never noticed that I can change the format of the output.
b: just a note if you have any numbers with leading zeros in the data (some zipcodes, etc): if you save the file with a csv extension excel will open it and drop the zeros, if you save it as .txt and then open it in excel you will get a text import wizard, the wizard will allow you to set that column as text so it comes in correctly.
Thanx a lot….
Thanks a lot ,real help to me.
Thx…Really Appreciated
You can also do this by going to Tools/Options/Result/Query Results/Results to Grid. Check Include column headers when copying or saving results.
Run your query in Grid mode
Select all records by clicking the top left corner of the grid and then right click and click on “Copy with headers”
I find this easier since I always like my query results in grid view. Also because by pasting the results from text results in having all the column names on the same cell