在SQL Server 2008中的存储过程中导出为CSV(Export to CSV in stored procedure in SQL Server 2008)

 我有一个存储过程，创建一个临时表，并有大量的数据。 我尝试了以下两种方法。 我可以使用导出实用程序手动执行此操作或将结果导入文件设置，但我想将代码嵌入到我的存储过程中，以便我可以安排批处理作业并忘记它。 我也不希望我们SSIS有很多原因。 
 
 我发现的热门解决方案是： 
 
bcp "select * from WHSE.Customer" queryout ExcelTest.csv -t, -c -S . -d Server1 -T

SQLCMD -S . -d Server1 -Q “"select * from WHSE.Customer sp” -s “,” -o “d:\result.csv
 
 在BCP中，它在BCP上出错，如果我在前面添加了EXECUTE ，我会收到错误： 
 
 
 
 'queryout'附近的语法不正确。 
 
 
 除了SQLCMD或-S上的错误之外， SQLCMD也是如此，这取决于我是否使用Execute命令。 
 
 这似乎应该很简单，我已经找到了很多答案，但没有一个真正起作用。 它似乎应该是世界上最基本的东西， SELECT * INTO MYFILE.CSV FROM MYTABLE 。 

I have a stored procedure that creates a temp table and has tons of data. I have tried both of the following. I can do it manually with the export utility or results to file settings, but I would like to embed the code in my stored procedure so I can schedule the batch job and forget it. Also I do not want to us SSIS for many reasons. 
 
Popular solution I have found are : 
 
bcp "select * from WHSE.Customer" queryout ExcelTest.csv -t, -c -S . -d Server1 -T

SQLCMD -S . -d Server1 -Q “"select * from WHSE.Customer sp” -s “,” -o “d:\result.csv
 
In the BCP it get an error on BCP, if I added an EXECUTE in front I get an error: 
 
 
 
Incorrect syntax near 'queryout'.
 
 
The same goes with the SQLCMD except error on SQLCMD or -S depending on if I use the Execute command. 
 
This seems like it should be simple and I have found TONS of answers, but none actually work. It seems like it should be the most basic thing in the world, SELECT * INTO MYFILE.CSV FROM MYTABLE essentially. 

原文：https://stackoverflow.com/questions/34346000