I have an asp page that is firing off a Transact-SQL stored procedure that selects rows, etc. What I need for it to do is write to a CSV file. Can I code this in the stored procedure? Can't seem to find anything for this....
Please help ::)
Thank you very much for the replies, but I guess I forgot to mention one thing in the original question.
The user would like to be able to do an adhoc query from a webpage. He would like to be able to select fields, then click submit, and get a CSV file. So, what I really need to know is how...
I imagine that this isn't too difficult, but I've never actually written to a CSV file before.
I have experience with PL/SQL for Oracle, but not for MS SQL Server.
All I need to do is select several rows from several different tables, with a few conditions, then write that info. to a CSV file...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.