This article about T-SQL Unit Testing, written by S.A. Miller shows the big picture. TSQLUnit is an open source unit testing framework for T-SQL written by Henrik Ekelund and available from http://sourceforge.net/projects/tsqlunit.