BCP_Export.bat
echo BCP作成 > D:/K.log
cd /d D:/
set DBNAME=jack
set UNAME=sa
set PNAME=sa
set SNAME=127.0.0.1
bcp jack..Student out Student.txt -U%UNAME% -P%PNAME% -S%SNAME% -c -b50000 >>k.log
bcp jack..Student_bak out Student_bak.txt -U%UNAME% -P%PNAME% -S%SNAME% -c -b50000 >> k.log
PAUSE
BCP_Import.bat
echo BCP作成 > D:/k.log
cd /d D:/
set DBNAME=jack
set UNAME=sa
set PNAME=sa
set SNAME=127.0.0.1
sqlcmd -U%UNAME% -P%PNAME% -S%SNAME% -d%DBNAME% -Q"truncate table Student"
bcp jack..Studentin PCM_zaimudata.txt -U%UNAME% -P%PNAME% -S%SNAME% -c -b50000 >> k.log
sqlcmd -U%UNAME% -P%PNAME% -S%SNAME% -d%DBNAME% -Q"truncate table Student_bak"
bcp jack..Student_bak in Student_bak.txt -U%UNAME% -P%PNAME% -S%SNAME% -c -b50000 >> k.log
PAUSE
注:BCP导出时, 【导出文件目录 】不能 与 【 bat文件】同一级(同一目录) 中 。