Post reply

Include Column Headers From SSMS

  • June 13, 2008 at 1:37 pm

    #828771

    shashi kant (6/13/2008)

    HI,

    There is other alternative available for this header option

    You can get this option by selecting these options

    Query -> Query Options ->Results -> and then select the option of Include column headers when copying or saving the results

    Regards

    Shashi Kant Chauhan 😎

    FYI - I believe that only sets the options for that particular query. You need to use the Tools->Options route to enable the headers for all queries going forward.

    -Marianne

  • June 13, 2008 at 1:45 pm

    #828778

    Thanks for the great tip!!!

  • June 13, 2008 at 2:33 pm

    #828809

    Hey thanks for posting this! I've been dealing with the inconvenience of writing out the column names by hand for a long time now lol...

  • October 13, 2009 at 5:23 am

    #1065131

    Great Tip.

    Tools > Options

    + Query Results

    + SQL Server

    Select 'Results to Grid'

    Check ' Include column headers when copying or saving results'

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply