SQL SERVER Query result in CSV format is possible?

Question

Hi,

Is it possible to get the query result in .CSV file format from SQL SERVER 2000 and above versions?

If so can we use this feature from an asp.net application to get the result in CSV format?

If so how can we do this?

Answer 1

You should explicitly loop through the DataTable results and build teh CSV file yourself.