SQLServer: Export SQL result into CSV file 导出SQL结果到CSV文件
sqlcmd -E -iC:\test.sql -oC:\testSQLOutput.csv -s"," -h-1 -W
也可以直接查询
sqlcmd -E -Q"select * from test.guest.test" -o"C:\testSQLOutput.csv" -s"," -h-1 -W
(-h是去掉标题,标头值必须是 -1 或是介于 -1 和 2147483647 之间的值)
SQL in test.sql:
SELECT * FROM DavidTest.dbo.LiGuoliangComUsers;
All result should be export into the csv file.
摘自:http://liguoliang.com/2012/sqlserver-export-sql-result-into-csv-file-%E5%AF%BC%E5%87%BAsql%E7%BB%93%E6%9E%9C%E5%88%B0csv%E6%96%87%E4%BB%B6/