sql stored procedure clear resultsets

Can I clear 开发者_JAVA百科the multiple result sets that a stored procedure has already gathered so that the next result set that is created becomes the very first result set returned by the procedure?

this would depend on the Database. In Sql Server, once the result set is sent, it is gone. The receiving application/code must deal with it. If you need to have logic like this, gather the results into a temp table and only return what is needed at the end of the procedure.

As KM said it depends a bit on the database. Can you explain how your stored procedure gather multiple result sets? Are you achieving this via multiple unions or by creating a dynamic sql statement ?