This article describes how to automate tests for T-SQL code using the T.S.T. tool.
T.S.T. is a tool that provides an API designed to write test automation for T-SQL code. While this API is similar to those found in some Unit Test libraries familiar to programmers in C# or Java, the API itself is written in T-SQL so the learning curve for someone already familiar with SQL programming is minimal. The T.S.T. API is isolated in a dedicated database that is installed when the tool is setup. The installation takes just a few seconds.
Sources, downloads and documentation are available on the Codeplex web site here.
Watch a short video.
Read the full article on SqlServerCentral.