Viewing multiple result sets
There are two instances where multiple query result sets might be returned. The first instance is as a result of running a stored procedure. The second instance is as a result of running a single query that has multiple SQL statements.