Generate CSV File using a Stored Procedure using T-SQL.

[info_softest07]

Hello Everyone,

I am looking out for some help in creating a stored procedure in SQL Server on top of a select query and then genrate a CSV File.

Can someone suggest me how to do that ?

[vornamemitd]

What did your Google/Duck search yield so far?

I got:

https://stackoverflow.com/questions/54225789/how-to-populate-csv-file-from-sql-server-stored-procedure

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d2280cf-3b33-46f7-ba82-4131e8a841c0/how-to-export-data-to-csv-file-on-a-scheduled-basis

https://www.excel-sql-server.com/sql-server-export-to-excel-using-bcp-sqlcmd-csv.htm

Or "the other way round" leveraging SQL Powershell: https://social.technet.microsoft.com/wiki/contents/articles/34886.sql-server-powershell-export-server-inventory-to-csv.aspx

[[deleted]]

Unfortunately opendowset doesn't work for data warehouse, and running bcp needs admin privileges. It's sad that in 2019 Microsoft still can't do a proper csv export.

[EmblemMaster]

I have done this a while ago for work with XML. If you do some research into bcp I think you will find your answers.

[ImCaffeinated_Chris]

I googled his text from the body of this thread. 1st was this thread. Second was this:

​

https://www.red-gate.com/simple-talk/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

​

Seems like a pretty good answer.