tSQLt is a unit testing framework for MS SQL-Server. A lot of information about unit testing in SQL, including a tutorial for tSQLt you can find at sqlity.net.

tSQLt itself you can download at https://sourceforge.net/projects/tsqlt/.