I posted yesterday on pulling the column headings from a SQL Server result set and transferring them to Excel. I received a comment from Scott Stonehouse outlining a much easier way to do what I need to do.
Simply access the Tools Menu and select Options. On the left, expand Query Results/SQL Server and select Results to Grid. On the right check Include column headers when copying or saving the results.
Run a query in SQL Server Management Studio and select the contents of the result set.
Paste the results into Excel – like magic, there are the column headings.
To me, Scott proved what the Internet and blogs are for. Teaching and Learning.
[...] Column Headings from SQL Results – Easier Way (Rhonda Tipton) [...]
By: Dew Drop - April 25, 2008 | Alvin Ashcraft's Morning Dew on April 25, 2008
at 7:02 am
Glad I could help! Trust me, I’ve learned lots from reading your stuff!
By: scottstonehouse on April 25, 2008
at 6:55 pm
[...] Column Headings from SQL Results – Easier Way [...]
By: Social Networks/Blogging and Self-Improvement « Rhonda Tipton’s WebLog on May 7, 2008
at 6:43 pm