The functionality of Unit Test allows you to develop stable and reliable code that can be properly regression-tested at the unit level.
Unit Test uses the open-source tSQLt framework, a set of T-SQL tables, views, stored procedures, and functions. Learn how to install the framework.
Installing the example database and running the example tests are explained in plain English.
With Unit Test for SQL Server, you can run as many tests as you want with one click. Get to know how.
Check a worked example of a failed test and an efficient way to fix it.