all groups > sql server mseq > july 2003 >
You're in the

sql server mseq

group:

Outputting SQL results


Outputting SQL results Wayne Freeman
7/23/2003 4:51:02 AM
sql server mseq:
I am trying to output the results of a SQL query (Server
2000) to a text file that can be sent to an internal web
page. I can view the resulting data in a view via
Enterprise Manager, but cannot figure out to output
Re: Outputting SQL results Vishal Parkar
7/23/2003 6:24:09 AM
Open query analyzer
Press "Ctrl + D"
Run the query from Query analyzer against the view like :"select * from
view"

The output will be shown in grids. Right click on the grid and click on
"save as" to save output to the file.

--
-Vishal
[quoted text, click to view]

AddThis Social Bookmark Button