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];