bulk insert 总结

--utf-8格式的，ROWTERMINATOR设置成'0X0A'，如果出现中文乱码，加上CODEPAGE='65001'，需要Microsoft® SQL Server® 2014 Service Pack 2 (SP2)补丁
bulk insert lis_tb_pub_bm_business_2019 from 'H:\数据\ods_import-lis_tb_pub_bm_business_2019.txt'
 with (
      FIELDTERMINATOR = '|',
      ROWTERMINATOR = '\n',
      CODEPAGE='65001'
 )

bulk insert lis_tb_pub_bm_business_2019 from 'H:\数据\ods_import-lis_tb_pub_bm_business_2019.txt'
 with (
      FIELDTERMINATOR = '|',
      ROWTERMINATOR = '0X0A'
 )