SQL server 2016 table insert in bulk code example
Example: Simple Bulk insert TSQL csv
BULK
INSERT
[SALES].[Flowers]
FROM 'C:\x\Learning\SQLServer2008DatabaseDev\FlowersData.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO