SQL SERVER Query result in CSV format is possible?

Is it possible to get the query result in .CSV fil开发者_C百科e 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?

---

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