Press "Enter" to skip to content

Testing a Stored Procedure with tSQLt

Olivier Van Steenlant runs a test:

In the previous data recipe, Create a Test Class & First Unit Test with tSQLt, we created our very first T-SQL Unit Test to test the database collation. In this data recipe, we will test the execution of a Stored Procedure. Specifically, we will validate what happens when a new User is added to the user dimension.

Click through to see how it all works.