How To Retrieve Multiple Result Sets from a Stored Procedure (147814)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Access 2.0
This article was previously published under Q147814 SUMMARY
Microsoft Access version 2.0 for Windows introduced a new type of
SQL-specific Query called a SQL pass-through (SPT) query. This query allows
you to execute SQL commands that are specific to a back-end database server
such as Microsoft SQL Server. It also lets you group or batch multiple SQL
statements that return multiple result sets or execute a stored procedure
on the server that returns multiple result sets.
The information in this article demonstrates how to take advantage of this
new query type to execute a batch of SQL statements that select multiple
result sets into temporary tables, which you can then open and modify
within your Visual Basic program.
Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
---|
Keywords: | kb16bitonly kbhowto KB147814 |
---|
|