TST (T-SQL Test Tool)


TST (the T-SQL Test Tool) is a software 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.TST Features:
1. Support for validating views as well as stored procedures and functions that return a table.
2. A reliable implementation of Assert.Equals / Assert.NotEquals procedures that 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.
3. Ability to run concurrent test sessions against the same or different databases.
4. Ability to produce XML results.
5. Automatic rollback of the database changes done during each test.
6. TST will detect when its own rollback mechanism becomes inimpactful in some scenarios that involve testing code that uses transactions. The TST rollback can be disabled at the test, suite or global level.
7. No need to register the test stored procedures; they are picked up automatically by the TST test runners.
8. Can be run from the command prompt or directly by calling one of the test runner stored procedures.
9. The TST infrastructure is isolated in a separate database.
10. Easy to install and integrate with other test frameworks.
11. Does not have any dependencies besides SQL Server.
12. Very small learning curve for someone already familiar with T-SQL.

Published By:tst.codeplex.com

License Type:Freeware

Date Added:02 June, 2012




Size:1.4 MB

Platform: Macintosh

What people say
- required fields
Related Downloads

HTTP Test Tool is a script based tool for testing and benchmarking web applications, web servers, proxy servers and web browsers. httest can emulate clients and servers in the same test script, very useful for testing proxys

DateSep 25, 2014


Size:3.2 MB





dbForge SQL Complete Express is a free IntelliSense add-in for SQL Server Management Studio. It offers autocompletion and formatting of T-SQL code. The tool supports SQL Server 2000, 2005, 2008,2012, 2014, SQL Azure and SQL Server Compact edition

DateSep 22, 2015


Size:14.0 MB


PlatformWindows, Windows 8, WinVista, WinVista x64


dbForge SQL Complete Express

A free SQL autocomplete tool. Completion tool for query composing in SQL Server Management Studio

DateSep 25, 2014


Size:8.0 MB



CategoryDatabases & Tools

Instant SQL Data Recovery is possible with MDF SQL Recovery Tool.

DateSep 25, 2014

AuthorSQL Recovery

Size:1.5 MB



PlatformWin98, WinME, WinXP, Windows 2000

CategoryFile & Disk Management

MDF SQL Recovery Tool

A power SQL Query Tool for and DBMS, supporing Oracle, SQL Server, MySQL, PostgreSQL, DB2, Access, Foxpro, Excel, DSN and so on. * Provides Console Application (sqla.exe) and Windows Graphical User Interface (GUI) Application (wsqla.exe).

DateSep 25, 2014

AuthorSQLAll Inc

Size:409.6 KB



PlatformWin XP/2003/2000/Vista

CategoryDatabases & Tools