SQL Server, How to save headings in query results?

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> How to save headings in query results?

by KK » Fri, 17 Sep 2004 23:41:50 GMT

In query analyzer when I run a query it displays
the query results in the reulsts pane with column
headings, but when I save the file, it doesn't save
column headings. I already checked in Tools -> Options ->
Results - Print Column Headers(*) is checked.

How can I save the column headers? Otherwise I have to
manually enter it in the spreasheet.

Thank you,
KK


Top

SQL Server >> How to save headings in query results?

by Tom Moreau » Sat, 18 Sep 2004 00:32:45 GMT


Consider running the same query via a DTS data pump to a flat file. You can
check on the option to include headers.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql




In query analyzer when I run a query it displays
the query results in the reulsts pane with column
headings, but when I save the file, it doesn't save
column headings. I already checked in Tools -> Options ->
Results - Print Column Headers(*) is checked.

How can I save the column headers? Otherwise I have to
manually enter it in the spreasheet.

Thank you,
KK



Top
Similar Threads

1. Saving SQL Query Results with Column Headings 

Is there a way to save the results with grid column headings from the Query
Analyzer in an CSV file?

Thanks,
Eli

2. save an query by sql code and deleting the saved query

3. Saving prediction query results to a relational table 

How do I save the prediction query results to a relational table outside of the BI studio?

4. saving the query analyzer results to .rpt format and opening it in a xlsheet - SQL Server DTS