TechNet
Export (0) Print
Expand All

IRowsetFastLoad (OLE DB)

 

Applies To: SQL Server 2016 Preview

The IRowsetFastLoad interface exposes support for SQL Server memory-based bulk-copy operations. SQL Server Native Client OLE DB provider 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.

MethodDescription
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.

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

Community Additions

ADD
Show:
© 2016 Microsoft