SQL SERVER Query result in CSV format is possible?

Question

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?

simple-talk.com/sql/database-administration/… looks applicable. I don't know SQL Server. — msw
– msw, Commented May 21, 2010 at 6:45

David Hall · Accepted Answer · 2011-12-11 17:55:30Z

1

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

David Hall

33.3k10 gold badges93 silver badges129 bronze badges

answered May 21, 2010 at 6:58

Raj

1,7701 gold badge12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1