ImportRowsPerBatch Property
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The ImportRowsPerBatch property specifies the number of rows contained in a bulk-copy transaction.
Syntax
object
.ImportRowsPerBatch [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A long integer greater than 0
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetImportRowsPerBatch(LPLONG pRetVal);
HRESULT SetImportRowsPerBatch(LONG NewValue);
Hinweise
The Microsoft SQL Server bulk-copy process can copy large amounts of data from an external data file to a SQL Server table. By default, a bulk-copy data-import operation inserts all rows in the data file in a single transaction. SQL Server does not guarantee data integrity until and unless a bulk-copy transaction is committed.
Use ImportRowsPerBatch to adjust the size of the bulk copy transaction.