TSQL Challenge – Basic Testing Sandbox
We have recently integrated email notification feature to the basic testing process. This will send out an email with the success/failure status of each solution to its author. TSQL Challenge 19 is the first challenge that had this feature.
Right after the testing, I got a number of emails from people who received a failure notification. Most of them wanted to know why their solution failed even though it looked correct to them.
We have created a Basic Testing Sandbox for TSQL Challenge 19. We intend to do this for all the future challenges as well. Take a look at http://databasechallenges.com/SQLServer/TSQL/Challenge19/Basic_testing_sandbox which gives you a template to test your solutions against the basic testing data and make sure that it produces the expected results.
This can help in a number of ways. If you received a failure notification email during the basic testing, you can test your solution against this sandbox and figure out what is wrong with your solution. Before submitting a new solution, you can test your solution against this template and verify that the output is correct.
I am very eager to hear what you all think about this.