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
    Permalink

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

    Reply
  • June 2, 2009 at 4:59 am
    Permalink

    Very helpful. Many thanks.

    Reply
  • July 22, 2009 at 9:18 am
    Permalink

    Nice one man!! Saved me a bunch of time

    Reply
  • December 4, 2010 at 7:38 am
    Permalink

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

    Reply

Leave a Reply

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

%d bloggers like this: