Anyone done any of this? Testing a stored procedure involves
- set up test data - run the procedure - check and report on results - any clean up needed (remove or restore output data, reset generators, ect ect) and setting this all up is somewhat non-trivial, but then so is manually checking the results of a procedure which can do quite complicated things to a dozen or more tables. So it would be nice to have a framework into which we could "just" drop "a few scripts" describing the input data, the expected output data, and the procedure(/query/script/whatever) to run. Does such a thing exist? -- Tim Ward
