Isaiah Melendez
asked on
export sql results to csv
what is the best way to do this via TSQL
Use BCP Out
Use BCP utility
bcp "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" queryout "D:\MyTable.csv" -c -t , -S SERVERNAME -T
http://dba.stackexchange.com/questions/23566/writing-select-result-to-a-csv-file
--
declare @sql varchar(8000) = ''
set @sql='exec master..xp_cmdshell ''bcp "select * from yourTable" queryout c:\temp\xxx.csv -c'''
exec(@sql)
--
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This ultimately helped us find the solution. Thank you!