Originally posted by ms_sql_dba
actually the proposed query will return this:
| | |
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt
this means that the heading will not be suppressed, but rather renamed to empty strings.
in order to suppress the headings uncheck Print Column Headers in Tools/Options/Results of your query analyzer.
This question is related to the reply, is it possible to "uncheck Print Column Headers" with actually going to Tools>Options>Results? Is there is a script that would do that same? For example in Oracle you can say: