Hiding the Title Output ?

is there a way to suppress the output of the title of each column ?

i.e.

if that query would normally return

Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

Can i get it to return just:

John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prtwhere ru runing this script? in QA?|||yes you can
select name as ' ' ,age as ' ',rank as ' ' from table_name

Originally posted by ontheDB
is there a way to suppress the output of the title of each column ?

i.e.

if that query would normally return

Name | Age | Rank
John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt

Can i get it to return just:

John 12 Lt
Paul 11 Cpt
George 10 Sgt
Ringo 6 Prt|||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.|||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:

Set Headings off

Is this possible in Query Analyzer 2000?