The Batch Mode of SQL Server bulkInsert.

Possible Values

Data Type

string

Default Value

"STANDARD"

Remarks

BCP transfers data to SQL Server directly with BulkLoadBCP protocol through the TCP communication between client and server, which only supports INSERT statements. STANDARD uses standard INSERT, UPDATE and DELETE statements for batch operations.