Alexander Kuznetsov (11/13/2008)
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;
Hello Alexander.
1) for an UNordered result set, use the regular "Query" operation. This can be seen in most of the examples. Take a look at the http://localhost:8085/DemoSuite.AdHocQueries page. The test will only check for Ordered results if you use the "Ordered Query" operation.
2) Two or more result sets does not work. Only the first result set returned will be shown and tested.
3) To test any result set, use either the "Query" or "Ordered Query" operations. It does not matter what else the Stored Procedure does.
Take care,
Solomon...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR