Unit testing has been a common and accepted practice in application development for a long time. By testing certain functions and areas – or units – of code, it verifies those functions work as expected, and improves the quality of code.
tSQLt brings the same advantages to SQL Server database development, and is compatible with all editions of SQL Server from the 2005 Service Pack 2 edition onwards.
Importantly, because tSQLt allows you to implement unit tests in T-SQL, you don’t have to switch between various tools to create the code and unit tests. tSQLt also provides the following features to make it easier to create and manage unit tests: