BULK INSERT

BULK INSERT is a SQL statement in the DML Statements category. SQL Server high-speed bulk data import from a file. The syntax is BULK INSERT table_name FROM 'data_file' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\ ');. It returns rows inserted. A typical example: BULK INSERT employees FROM 'C:\data\employees.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\ ', FIRSTROW = 2, TABLOCK ); -- Fast import with field terminator, skipping header row A close relative is INSERT INTO, which inserts new rows into a table. A close relative is UPDATE, which modifies existing rows in a table. Always use WHERE to avoid updating all rows. A close relative is DELETE, which removes rows from a table. Always use WHERE to avoid deleting all rows. More about this category: Data Manipulation Language — INSERT, UPDATE, DELETE, REPLACE, MERGE. Related DML Statements entries: INSERT INTO, UPDATE, DELETE, REPLACE INTO, INSERT ... ON DUPLICATE KEY UPDATE, MERGE, INSERT INTO SELECT, UPSERT (PostgreSQL).