CSV import using Bulk Insert

 Import csv file to sql server is a common task for DBA's and Database Developers.
The syntax is as follows.
BULK INSERT dnd  /* Table */
FROM 'c:dnddnd_numbers.csv' /* csv file*/
WITH (fieldterminator = ',',
      rowterminator = 'n')
print

Leave a Reply

Your email address will not be published. Required fields are marked *


+ eight = 15