Column Headings from SQL Results - Easier Way
Posted by Rhonda Tipton on April 24, 2008
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.
April 25, 2008 at 7:02 am
[...] Column Headings from SQL Results - Easier Way (Rhonda Tipton) [...]
April 25, 2008 at 6:55 pm
Glad I could help! Trust me, I’ve learned lots from reading your stuff!
May 7, 2008 at 6:43 pm
[...] Column Headings from SQL Results - Easier Way [...]