bcpjwbz.bat

数据倒入导出

 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzDepartmentDuty.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzOfficerDistributeScale.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzOldUnitSoldiersSort.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzPrecept.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzPreceptType.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzPreceptUnitList.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzSortList.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzTableFile.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzTrainingUnitInfo.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzUnitCode.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzUnitPertainInfo.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzUnitPlaceList.txt" -c -q  -S"czy" -U"sa" -P"" 
 bcp "Select * from jwbz.dbo.t_jwbzUnitCode"  out "D:\文件接收\文件接收1068\Exportt_jwbzUnitSoldiersSort.txt" -c -q  -S"czy" -U"sa" -P""