import csv file to SQL temp table

import_csv_to_sql_temp_table.sql

IF OBJECT_ID('tempdb..#temp', 'U') IS NOT NULL DROP TABLE #temp;

CREATE TABLE #temp (
  ID int NOT NULL,
  [Name] nvarchar(50)
);

BULK INSERT #temp
FROM 'C:\AppData\fruits.csv'  -- CSV file path
WITH
(
    FORMAT = 'CSV', 
    FIELDQUOTE = '"',         -- Default value
    FIRSTROW = 2,             -- Start import from the 2nd row
    FIELDTERMINATOR = ',',    -- CSV field delimiter
    ROWTERMINATOR = '\n',     -- Use to shift the control to next row
    TABLOCK
);

SELECT * FROM #temp;