Do test-driven database development in SQL Server Management Studio. If you want to do test-driven development for databases, SQL Test is the place to start. It lets you write database unit tests in T-SQL and run them in SQL Server Management Studio. It’s simple to set up, you don’t need extra tools, and you don’t need to learn new technologies.
Write your tests in regular T-SQL
SQL Test uses the open-source tSQLt framework, a set of T-SQL tables, views, stored procedures, and functions. Tests are simple queries which use the framework to check the values of your data types and to mock database objects.
Tests won't change your database
SQL Test stores its objects in a separate schema, so they won’t get in your way. The tests run in transactions, which rolls back any changes. You won’t need any clean-up code.