Subject Unit testing for stored procedures?
Author Tim Ward
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