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)
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
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