This topic has not yet been rated - Rate this topic

IRowsetFastLoad (OLE DB)

SQL Server 2012

SQL Server 2005

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.

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.

Tasks

Bulk Copy Data Using IRowsetFastLoad (OLE DB)

Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)

Reference

Interfaces (OLE DB)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD