TST is a tool that simplifies writing and running automated tests for code written in T-SQL. At the heart of the TST tool is the TST database. This database contains a series of stored procedures that represent a test API. Part of this API is similar with those found in Unit Testing libraries familiar to programmers in C# or Java.
-Support for validating views as well as stored procedures and functions that return a table.
-A reliable implementation of Assert.Equals / Assert.NotEquals procedures. They detect when a comparison should not be made due to incompatibility of the data types. Additional procedures like Assert.NumericEquals, Assert.NumericNotEquals, Assert.FloatEquals, Assert.FloatNotEquals are provided.
-Can run concurrent test sessions against the same or different databases.
-Can generate XML results.
-Automatic rollback of the database changes done during each test.
-TST will detect when its own rollback mechanism becomes ineffective in some scenarios that involve testing code that uses transactions. The TST rollback can be disabled at the test, suite or global level.
-No need to register the test stored procedures; they are picked up automatically by the TST test runners.