备份
EXEC master..xp_cmdshell ‘bcp “pubs..sysobjects” out “c:/a.txt” /S”localhost” /U”sa” /P”mdcija” /c
还原
EXEC master..xp_cmdshell ‘bcp “pubs..sysobjects” in “c:/a.txt” /S”服务器名” /U”用户名” /P”密码” /c’
http://www.gaodaima.com/35909.htmlBCP的使用技巧_sqlserver
欢迎大家阅读《BCP的使用技巧_sqlserver》,跪求各位点评,若觉得好的话请收藏本文,by 搞代码