I don't want header in my output

[gussifinknottle]

I don't want the header in my output when I do a Select Query. Is there any way I can programmatically change this, other than doing either of the following:

*SELECT <col_name> AS ' '

OR

Unchecking the Print Options in the Connection Options of the Query Analyzer.

I am looking for something like as 'SET NOROWCOUNT ON', which I can incorporate in my code.

 

[tlbroadbent]

The column headings and dotted lines are controlled by the tool, Query Analyzer, not by SQL Server. SQL Server just sends back the data, the tool decides how to display it. You can turn the headings off in Query Analyzer by setting the current connection options.

If you are coding database access using ADO, ODBC, DAO, etc. SQL will not return headings. You'll have to add them if you want them. Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.