CREATE TABLE #entities (
Model nvarchar(max),
Entity nvarchar(max),
Description nvarchar(max)
); -- some fields, need from csv file
BULK INSERT #entities
FROM 'D:\test\entities.csv' -- some csv file into the file system
WITH
(
FIRSTROW = 2,
DATAFILETYPE='char',
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n',
TABLOCK,
KEEPNULLS
);
select * from #entities;
drop table #entities;
