将多个CSV批量导入SQL Server表中

--下例是将E:\CSV_Tmp\S001.CSV   至   S010.CSV导入tmps表

declare @x varchar(500)
declare @i int
set @i=1

while @i<=10
begin
	set @x='BULK INSERT tmps '
	set @x=@x+'FROM ''E:\CSV_Tmp\S0'+right('0'+CONVERT(varchar(2),@i),2)+'.csv'''
	set @x=@x+'WITH(FIELDTERMINATOR ='','',ROWTERMINATOR =''\n'',FIRSTROW=2)'
	exec(@x)
	set @i=@i+1
end