Example MultiRecords:

       Typically, we send one SQL statement to a server for generating one rowset only. If an OLEDB provider enables us to send a batch statement which would produce multiple rowsets and send all of records of all the rowsets using one stream if possible, it will be the best. It definitely increase performance! MS SQL Server provider supports this kind of batch statement.

        This example demonstrates how to use a batch statement with parameterized stored procedure and a SQL select statement by use of template class CMultiBulkRecord<T>. Here is the list of questions to be answered.

1. How to use a CMultiBulkRecord<T> object to deal with a complicated batch statement like "Select * from Orders;Insert Into Shippers Value(......);Call GetEmpInfoEx(?, ?, ?)".

2. How to move from one rowset to another rowset.

3. How to get new multiple rowsets after resetting a new set of parameters.