tSQLt – read all about it
tSQLt is the only open-source unit testing framework to enable true ci/cd for SQL Server. By embracing unit testing (and TDD) with tSQLt and integrating it in your ci/cd pipelines, you can deliver faster, better value to your end-users.
Why you should unit test SQL Server code
Why you should use the tSQLt framework