Export (0) Print
Expand All

INSERT Requirements for OLE DB Providers

Transact-SQL INSERT statements can reference remote tables only if the following conditions are met by the OLE DB provider that is used to access the remote table:

  • The provider must support the IRowsetChange interface on the rowset opened through IOpenRowset on the table that is having data inserted into it.

  • The IRowsetChange interface on the base table being inserted into must support the InsertRow insert method.

Community Additions

ADD
Show:
© 2014 Microsoft