How to Save Column Names with Results : SQL Server 2005

Whether you are copying query output from SQL Server Management Studio or Saving result as .csv file, if you need to save the column name or column header along with result.. here is simple option you have to enable.

Goto Query > Query Options or Press CTRL + Shift + O

Goto Option Grid Under Results

Check the box which says “Include column headers when copying or saving the results”

Click OK.

Run the query and save result as .csv or copy paste to excel with column headers. 🙂

Save Column Header With result

7 thoughts on “How to Save Column Names with Results : SQL Server 2005

  • December 22, 2008 at 4:39 am

    Hi ,
    Thanks a ton ..
    really superb.we struggled a lot for copying the column

  • June 2, 2009 at 4:59 am

    Very helpful. Many thanks.

  • July 22, 2009 at 9:18 am

    Nice one man!! Saved me a bunch of time

  • December 4, 2010 at 7:38 am

    Thanks so much… I was so frustrated for days without knowing this!


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: