| title | IRowsetFastLoad (OLE DB driver) | |
|---|---|---|
| description | OLE DB Driver for SQL Server consumers can use the IRowsetFastLoad interface to rapidly add data to an existing SQL Server table. | |
| author | David-Engel | |
| ms.author | davidengel | |
| ms.date | 06/14/2018 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | reference | |
| ms.custom |
|
|
| helpviewer_keywords |
|
|
| apitype | COM |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!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)