want no header row in output

Question

want no header row in output

Snargables

SSCrazy Eights

Points: 8855
More actions
November 21, 2016 at 11:40 am

#401102

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?

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

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

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 1

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.

Phil Parkin SSC Guru Points: 246988 More actions · Answer 2

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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

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