MSSQL 导入导出文本文件

 exec master..xp_cmdshell'net use \192.168.1.8 estfolder "0123" /user:192.168.1.8wjp'

EXEC master..xp_cmdshell 'bcp FH2_SJH.dbo.dCurrent in c: t.txt -c -t -S"SMARTSENCERSQL2008" -U"sa" -P"password"'

EXEC master..xp_cmdshell 'bcp FH2_SJH.dbo.band out c:and.txt -c  -t -S"SMARTSENCERSQL2008" -U"sa" -P"passwor"'

原文地址:https://www.cnblogs.com/smartsensor/p/3806920.html