• How would you test the following cases:

    - my stored procedure returns an unordered result set;

    - my stored procedure returns two result sets;

    - my stored procedure modifies two tables and returns a result set;