Writing unit tests to test the code is an inevitable practice in programming. Testing stored procedures are as important as the other code. Often SPs are tested manually, and we avoid adding an automated test. In an agile environment, code without tests are prone to defects at some point. In this article, let's see about tsqlt framework - an open source Database Unit Testing framework for SQL Server.
Pre-Requisites
- Code Editor (ex., IntelIj)
- SQL Database
Attach your Editor to the running database. The database can be running either in the local, cloud or in any VMs.