asked
Output query results to csv files
I have a query that returns 4 select result sets. Is there a way to output the results into 4 csv files from the query without having to click on each result set and "save result as" and selecting CSV file? Please advice if there is a better way of producing the csv files. thanks, Doug
That's something you can do in my [SQL Server IDE][1] - right click a result set and say 'save all to CSV'. Not sure how you would do that in SSMS though. Funnily enough, I don't use it that much :) [1]:
http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx
BCP using queryout
Is BCP using Queryout is only in windows command line? I try to run it in sql management studio and I get a incorrect syntax. I query the results into a temp table and ran the following script BCP " Select * from #Result1 Order by [Territory] ,[selltoCustCountryCode] ,Year ,CustCount " queryout Test.csv -c -T
I've enabled xp_cmdshell and try to run the below statement but I'm coming up with an error: Msg 155, Level 15, State 1, Line 3 'BCP' is not a recognized ODBC date/time extension option. This is new territory for me, can you please review the code below and let me know where I error out? EXEC xp_cmdshell { BCP ' Select * from #Result1 Order by [Territory] ,[selltoCustCountryCode] ,Year ,CustCount ' queryout Test.csv -c -T }
