• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13.  Recordset Objects > Working with Multiple Recordsets

Working with Multiple Recordsets

SQL Server can process SQL queries and stored procedures that return multiple resultsets. The Access user interface always displays the first resultset only in response to executing the following stored procedure, for example:

CREATE PROCEDURE MultipleResultsets
AS
/* This SP returns two resultsets;
 the second resultset could only retrieved with ADO */
		SELECT * FROM tblFilms
		SELECT * FROM tblProducts
RETURN


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint