bcpdemo2.bat

T-SQL示例大全

@echo OFF
cls
echo -------------------------------
echo 将数据表导出至数据文件
echo -------------------------------

bcp 北风贸易.dbo.章立民工作室 out c:\T-SQL\FoxStudio.txt -m 1 -e c:\T-SQL\FoxStudioError.txt -N -T

echo -------------------------------
echo 建立一个数据表以便将数据导入
echo -------------------------------

osql -E -Q "EXEC 北风贸易.dbo.CreatebcpTableProc 1"

echo -------------------------------
echo 开始将数据档中的数据导入数据表
echo -------------------------------

bcp 北风贸易.dbo.bcpTargetTable in c:\T-SQL\FoxStudio.txt -m 1 -e c:\T-SQL\FoxStudioError.txt -N -T


----------------------------------------------------------------
This file is converted by NJStar Communicator - www.njstar.com
----------------------------------------------------------------