want no header row in output

  • Is there a way to call a sql select w/o it returning the column header row? Is there some sort of setting i can run before the select?

  • Snargables (11/21/2016)


    Is there a way to call a sql select w/o it returning the column header row? Is there some sort of setting i can run before the select?

    That would entirely depend on what method you're using to call the SQL command, the column names are part of the data returned by the select. Most interfaces have some sort of option to include or exclude column headers just like when you copy and paste data out of SSMS which has a copy with headers and just a copy option.

  • Snargables (11/21/2016)


    Is there a way to call a sql select w/o it returning the column header row? Is there some sort of setting i can run before the select?

    What client is making the call?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • What, exactly, do you need to do with the data returned that makes you not want the column names?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 4 posts - 1 through 3 (of 3 total)

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