2.2.1.5 Bulk Load

In a bulk insert/bulk load operation, a SQL statement consists of a Unicode string that is followed by binary data. The client sends the INSERT BULK SQL statement and then sends a COLMETADATA token (section 2.2.7.4) that describes the raw data. Multiple rows of binary data are then sent to the server. The data is not formatted in storage row format but in the format described by the COLMETADATA token. The stream is the same as if the data were being selected from the server rather than being sent to the server. For more details, see section 2.2.6.1.

A bulk load operation is also used for inserting data with a previously issued UPDATETEXT BULK or WRITETEXT BULK SQL statement. For more details, see section 2.2.6.2.