| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | apitype | |
|---|---|---|---|---|---|---|---|---|---|---|
IRowsetFastLoad (OLE DB driver) |
OLE DB Driver for SQL Server consumers can use the IRowsetFastLoad interface to rapidly add data to an existing SQL Server table. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
COM |
[!INCLUDE SQL Server]
[!INCLUDEDriver_OLEDB_Download]
The IRowsetFastLoad interface exposes support for [!INCLUDEssNoVersion] memory-based bulk-copy operations. OLE DB Driver for SQL Server consumers use the interface to rapidly add data to an existing [!INCLUDEssNoVersion] table.
If you set SSPROP_ENABLEFASTLOAD to VARIANT_TRUE for a session, you cannot read data from rowsets subsequently returned from that session. When SSPROP_ENABLEFASTLOAD is set to VARIANT_TRUE, all rowsets created on the session will be of type IRowsetFastLoad. IRowsetFastLoad rowsets do not support rowset fetch functionality; therefore, data from these rowsets cannot be read.
| Method | Description |
|---|---|
| IRowsetFastLoad::Commit (OLE DB) | Marks the end of a batch of inserted rows and writes the rows to the [!INCLUDEssNoVersion] table. |
| IRowsetFastLoad::InsertRow (OLE DB) | Adds a row to the bulk copy rowset. |
Interfaces (OLE DB)
Bulk Copy Data Using IRowsetFastLoad (OLE DB)
Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)