Creating a Rowset with IOpenRowset
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
The OLE DB Driver for SQL Server supports the IOpenRowset::OpenRowset method with the following restrictions:
A base table or view must be specified in a database ID (DBID) structure that the pTableID parameter points to.
The DBID eKind member must indicate DBKIND_NAME.
The DBID uName member must specify the name of an existing base table or a view as a Unicode character string.
The pIndexID parameter of OpenRowset must be NULL.
The result set of IOpenRowset::OpenRowset contains a single rowset. Result sets that contain a single rowset can be supported by Microsoft SQL Server cursors. Cursor support allows the developer to use SQL Server concurrency mechanisms.