There are numerous articles out on the web about using tsqlunit framework to test your applications t-sql code. This is not going to be another article on how to use it. I just wanted to give you some information to read and decide for yourself.
You will need to sign-up for an account to read the article. But if you are not already a member you should be. This is a great resource for SQL Server.