CSV文件数据格式如下:
SQL脚本如下:
create table #temp5
(
ID INT ,
SiteKey NVARCHAR(100),
BeginTime NVARCHAR(100),
EndTime NVARCHAR(100),
RefWeek NVARCHAR(100),
RefNum NVARCHAR(100),
RefIncremental NVARCHAR(100)
);
declare @query varchar(1000);
set @Query ='BULK INSERT #temp5 FROM ''D:\Backup\桌面\新城集团数据审核配置.csv'' WITH ( FIELDTERMINATOR = '','',ROWTERMINATOR = ''\n'',FIRSTROW=2)'
exec (@query)
SELECT * FROM #temp5
DROP TABLE #temp5
结果如下所示: