commands-generating-multiple-rowset-results.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Commands generating multiple-rowset results (Native Client OLE DB provider)	Commands generating multiple-rowset results (Native Client OLE DB provider)	markingmyname	maghan	03/14/2017	sql	native-client	reference	multiple rowsets rowsets [OLE DB], multiple SQL Server Native Client OLE DB provider, commands SQL Server Native Client OLE DB provider, multiple rowsets commands [OLE DB] multiple-rowset results

SQL Server Native Client Commands Generating Multiple-Rowset Results

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]

The [!INCLUDEssNoVersion] Native Client OLE DB provider can return multiple rowsets from [!INCLUDEssNoVersion] statements. [!INCLUDEssNoVersion] 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.

Batches

The [!INCLUDEssNoVersion] 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.

Stored Procedures

[!INCLUDEssNoVersion] returns a result set for each statement in a stored procedure, so most [!INCLUDEssNoVersion] stored procedures return multiple result sets.

In This Section

• Using IMultipleResults to Process Multiple Result Sets

See Also

Commands