Rhonda Tipton’s WebLog

Random Subject Matters

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.

2008-04-24_084916

Run a query in SQL Server Management Studio and select the contents of the result set.

2008-04-24_085755

 

Paste the results into Excel - like magic, there are the column headings.

2008-04-24_085900 

To me, Scott proved what the Internet and blogs are for.  Teaching and Learning.

3 Responses to “Column Headings from SQL Results - Easier Way”

  1. Dew Drop - April 25, 2008 | Alvin Ashcraft's Morning Dew Says:

    [...] Column Headings from SQL Results - Easier Way (Rhonda Tipton) [...]

  2. scottstonehouse Says:

    Glad I could help! Trust me, I’ve learned lots from reading your stuff!

  3. Social Networks/Blogging and Self-Improvement « Rhonda Tipton’s WebLog Says:

    [...] Column Headings from SQL Results - Easier Way [...]

Leave a Reply

You must be logged in to post a comment.