导出格式:
bcp jinbi.dbo.Code format nul -f F:/DB/currency_format1.fmt -c -U sa -P a
导出数据:
bcp jinbi.dbo.Code out F:/DB/currency1.txt -c -U"sa" -P"a"
导入数据:
bcp jinbi.dbo.Code in F:/DB/jfcode.txt -f F:/DB/code_format.fmt -U sa -P a -m 9999999 -b 100
code_format.fmt
9.0
2
1 SQLCHAR 0 50 "," 4 CODE Chinese_PRC_CI_AS
2 SQLCHAR 0 50 "/r/n" 7 CODE16 Chinese_PRC_CI_AS