Import data from .csv to sql

to import data from .csv file to sql server you can use below query.

BULK INSERT ZIPCodes 
    FROM 'e:\yourCSVFileName.csv' 
    WITH 
    ( 
  FIRSTROW = 2 ,
        FIELDTERMINATOR = ',', 
        ROWTERMINATOR = '\n' 
    )