BULK INSERT tempdb.dbo.TMP_TEST FROM 'C:\DATA\ TMP_TEST.csv ' WITH (KEEPIDENTITY, FIELDTERMINATOR = '\t',ROWTERMINATOR = '\n',BATCHSIZE =1000 ) BATCHSIZE选项的必要性:针对大文件,大数据提交的情况非常必要 FIRSTROW: 已经导入数据的行数+1