Microsoft SQL server 2014 unit test

I am working on a project at uni. I am unit MS SQL server 2014 for database. I can't find much information about how to create unit tests for SQL procedures. Could you please provide me some example, how can i create unit test in server 2014 or any other method to test the procedures, thanks