将上传的新表导入临时全局表中

--表1 开户级别表 534848 852363 1387211
exec master..xp_cmdshell 'BCP ##jibie in
d:\FTP\threetable\test.txt -c -t"|" -r0x0A -T'
--表2 利率表 224 457
bulk insert ##lilv
from 'D:\FTP\threetable\F_CM_KITP_JIZHLL_20150930.dat'
with
(
codepage=65001,
fieldterminator='0x03',
rowterminator='0x0A'
)
--表3 机构表 97 63 160
bulk insert ##jigou
from 'd:\FTP\threetable\F_PT_ORG_KBRP_JGCSHU_20150930.dat'
with
(
codepage=65001,
fieldterminator='0x03',
rowterminator='0x0A'
)