Overview

• BULK INSERT Imports a data file into a database table or view in a user-specified format.

-- Microsoft Windows automatically replaces \\n with \\r\\n
BULK INSERT Sales.SalesOrderDetail
FROM 'C:\\Data\\Data.dat'
WITH (FIELDTERMINATOR =' |', ROWTERMINATOR =' |\\n')

Bulk Import/Export of XML Documents

INSERT INTO MyTable ([XmlCol])
SELECT * FROM OPENROWSET
(BULK 'c:\\SampleFolder\\SampleData3.txt', SINGLE_BLOB) AS [XmlCol];