Mistake #1: treating returned values as sufficient. A row count condition checks that a result set contains the expected number of rows, catching missing or extra results that scalar checks can overlook. section 7.5
Campaign test
A stored-procedure unit test uses CampaignID 27587, Budget 10, and Detailed set to 1. Alongside scalar checks, it requires the second result set to return exactly 42 rows. Run the test, inspect its status, and change an expected value to observe a failure; remember that a failing test may contain the error. section 7.5
Apply the condition with this checklist:
- Add a Row Count condition to the test and configure the expected result-set count. section 7.5
- Run all tests from Test Explorer, then drill into the test for granular status information. section 7.5
- Verify the test itself when a failure appears; the production code may be correct. section 7.5
Figure 7.6 Creating a unit test
Use the unit-test layout to locate test code, conditions, and configuration controls. section 7.5
