SQL Unit Testing Stored Procedures

Question

I am new to working with SQL database but have been confronted with testing my database. For security reasons any queries or updates are done through stored procedures.

It was suggested to me by a peer to use stored procedures to test other stored procedures. Is this a good or bad solution to unit testing my stored procedures to ensure they are doing what they are suppose to be doing?

Answer 1

I found an excellent solution using Visual Studio: Visual Studio Unit Testing

It allows you to create unit tests for SQL stored procedures, you can also populate the database using regular expressions - very cool stuff.