SSDL

If you use stored procedures, SSDL can make it easy to integrate test creation into your development process, so that coverage is more likely to always be complete. Code usage is also very simple, and all SQL, code and tests are organized into neat little self-contained units.

Source and documentation can be found at The Code Project.