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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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