MSSQL 导入导出文本文件

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

 

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

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