导入CSV到SQL SERVER 问题

DROP TABLE XXXXX CREATE TABLE XXXXX(a varchar(50),b varchar(50),c varchar(50), d varchar(50),e varchar(50),f varchar(50),g varchar(50),h varchar(50), i varchar(50),l varchar(50),k varchar(50),m varchar(50)) bulk insert xxxxx from 'c:\xxx.csv' with ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', FIRE_TRIGGERS ) /* 结果： a b c d e f g h i l k m -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- A00001 01231230 1 0 1 2 3 1 2 3 0 A00002 00134310,2,0,0,2,6,8,6,2,0 AB0003 NULL 2 2 NULL NULL NULL NULL NULL NULL AB0004 ,3,,,,,,,,3 (2 行受影响) */