在 SQL Server 中将 SELECT 语句的结果导出到文件的方法

gxh1968

　　exec master..xp_cmdshell
'bcp "SELECT* FROM tablename" queryout "C:\test.txt" -T -c -C 65001'

最后的参数 -T 表示这是信任的连接，也就是说不用输入密码了；-c 表示按字符类型输出；-C 65001 表示输出为 UTF-8 格式，其中 65001 是 UTF-8 的代码页。


bcp usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"] [-x generate xml format file]