Exporting query results into text file(csv)

Oct 27, 2009 at 6:55 AM


 i want to export the query results or stored procedure results in sql server to a text file with comma seperated values (csv).

how it is possible to do that.


Oct 27, 2009 at 7:00 AM

This isn't really the forum for this type of question, but what I normally do is cut and paste the results from the Query Analyzer grid into Excel and then save it in CSV format from there.

Oct 27, 2009 at 7:09 AM

that should be automated process. how it can be done ?