Edit

Share via


IRowsetFastLoad (OLE DB)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric

Download OLE DB driver

The IRowsetFastLoad interface exposes support for SQL Server memory-based bulk-copy operations. OLE DB Driver for SQL Server consumers use the interface to rapidly add data to an existing SQL Server 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.

In This Section

Method Description
IRowsetFastLoad::Commit (OLE DB) Marks the end of a batch of inserted rows and writes the rows to the SQL Server table.
IRowsetFastLoad::InsertRow (OLE DB) Adds a row to the bulk copy rowset.

See Also

Interfaces (OLE DB)
Bulk Copy Data Using IRowsetFastLoad (OLE DB)
Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)