Turn column headings off programmatically 
Author Message
 Turn column headings off programmatically

Quote:

>  I have written a query to create an HTML document containing a list of all the
>  records in a table.  I have used SET NOCOUNT ON to prevent the count from
>  appearing but I also need to prevent the column headings from appearing.  I
>  know it can be done by changing the configuration in the Query Analyser but I
>  need a way to do it within a query.  Any suggestions?

>    Todd

Queries always return both metadata and data. Whether the metadata is displayed as column headings is
controlled by the tool (such as Query Analyser), not by the server. Some tools do not have any support for
suppressing the metadata.

Kalen Delaney
Sound Software Services



Mon, 25 May 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Turn Column Headings Off via SQL?

2. Turning off the column headings...

3. Turn headings on & off through isql

4. Turning Headings Off

5. Turning Headings Off

6. Turning off headings and footings

7. Turn off Logging of TEXT columns ?

8. How do I Turn off Aggregate functions in my cube for selected rows/columns

9. How do I Turn off Aggregate functions in my cube for selected rows/columns

10. SQL SERVER - Turning off the IDENTITY Column through code

11. turn off column headers

12. set or any command to turn column headers off in sql7 query analyzer


 
Powered by phpBB® Forum Software