Commands Generating Multiple-Rowset Results
The SQL Server Native Client OLE DB provider can return multiple rowsets from SQL Server statements. SQL Server statements return multiple-rowset results under the following conditions:
Batched SQL statements are submitted as a single command.
Stored procedures implement a batch of SQL statements.
The SQL Server Native Client OLE DB provider recognizes the semicolon character as a batch delimiter for SQL statements:
WCHAR* wSQLString = L"SELECT * FROM Categories; " L"SELECT * FROM Products";
Sending multiple SQL statements in one batch is more efficient than executing each SQL statement separately. Sending one batch reduces the network round trips from the client to the server.
SQL Server returns a result set for each statement in a stored procedure, so most SQL Server stored procedures return multiple result sets.