TSQLUnit is a framework to write tests for applications written in Transact-SQL. It follows the tradition of the "xUnit" framework that is available for almost all programming languages.
- Simple, lightweight and straightforward.
- Can be used in complex scenarios.
- Includes unit tests in Python.
tsqlunit works nicely
I love this tool when working in sql server writing stored procedures! Except, I would like to expand the naming scheme for the test cases to include use case name which is really just your asp.net web page name addCustomer.aspx and have a three part nameing scheme a la Roy Osherove The Art Of Unit Testing...
Pretty good. I like it better than SQL Test because it has no encrypted code or proprietary CLR assembies. It's very small.
Very easy to use and very useful.
Lightweight, easy to install and uninstall. The best way to do TDD in T-SQL.