命令行下： bcp pubs.dbo.table1 in "d:\\t1.dat" -S . -U "sa" -P "123" -n bcp pubs.dbo.table1 out "d:\\t1.dat" -S . -U "sa" -P "123" -n 或调用SQL过程 exec master..xp_cmdshell 'bcp pubs.dbo.table1 in "d:\\t1.dat" -S . -U "sa" -P "123
命令行下：
bcp pubs.dbo.table1 in "d:\\t1.dat" -S . -U "sa" -P "123" -n
bcp pubs.dbo.table1 out "d:\\t1.dat" -S . -U "sa" -P "123" -n
或调用SQL过程
exec master..xp_cmdshell 'bcp pubs.dbo.table1 in "d:\\t1.dat" -S . -U "sa" -P "123" -n'
exec master..xp_cmdshell 'bcp pubs.dbo.table1 out "d:\\t1.dat" -S . -U "sa" -P "123" -n'
msdn：
http://msdn.microsoft.com/zh-cn/library/ms162802.aspx