The official tSQLt repository. (Download at: )
Switch branches/tags
successful-build successful-build-V1.0.5713.20521 successful-build-49 successful-build-48 successful-build-47 successful-build-46 successful-build-43 successful-2014 successful-2014-build-V1.0.5713.20521(2014) successful-2014-build-42(2014)(104) successful-2014-build-41 successful-2012 successful-2012-build-V1.0.5713.20521(2012) successful-2012-build-105(2012) successful-2012-build-104(2012)(53) successful-2012-build-52 successful-2008 successful-2008R2 successful-2008R2-build-V1.0.5713.20521(2008R2) successful-2008R2-build-104(2008R2)(67) successful-2008R2-build-68(2008R2)(105) successful-2008R2-build-66 successful-2008-build-V1.0.5713.20521(2008) successful-2008-build-54(2008)(104) successful-2008-build-53 successful-2005 successful-2005-build-V1.0.5713.20521(2005) successful-2005-build-60(2005)(104) successful-2005-build-59 build-V1.0.5873.27393(2014)-successful-2014 build-V1.0.5873.27393(2012)-successful-2012 build-V1.0.5873.27393(2008R2)-successful-2008R2 build-V1.0.5873.27393(2008)-successful-2008 build-V1.0.5873.27393(2005)-successful-2005 build-V1.0.5873.27393 build-V1.0.5873.27393-successful-all build-V1.0.5871.41606(2014)-successful-2014 build-V1.0.5871.41606(2012)-successful-2012 build-V1.0.5871.41606(2008R2)-successful-2008R2 build-V1.0.5871.41606(2008)-successful-2008 build-V1.0.5871.41606(2005)-successful-2005 build-V1.0.5871.41606 build-V1.0.5871.41606-successful-all build-V1.0.5871.41589 build-V1.0.5871.35366(2014)-successful-2014 build-V1.0.5871.35366(2012)-successful-2012 build-V1.0.5871.35366(2008R2)-successful-2008R2 build-V1.0.5871.35366(2008)-successful-2008 build-V1.0.5871.35366(2005)-successful-2005 build-V1.0.5871.35366 build-V1.0.5871.35366-successful-all build-V1.0.5871.32427(2014)-successful-2014 build-V1.0.5871.32427(2012)-successful-2012 build-V1.0.5871.32427(2008R2)-successful-2008R2 build-V1.0.5871.32427(2008)-successful-2008 build-V1.0.5871.32427(2005)-successful-2005 build-V1.0.5871.32427 build-V1.0.5871.32427-successful-all build-V1.0.5867.40892(2014)-successful-2014 build-V1.0.5867.40892(2012)-successful-2012 build-V1.0.5867.40892(2008R2)-successful-2008R2 build-V1.0.5867.40892(2008)-successful-2008 build-V1.0.5867.40892(2005)-successful-2005 build-V1.0.5867.40892 build-V1.0.5867.40892-successful-all build-V1.0.5867.27651 build-V1.0.5867.26122 build-V1.0.5867.18307 build-V1.0.5829.36272 build-V1.0.5793.20044 build-V1.0.5793.19431 build-V1.0.5793.18769 build-V1.0.5787.40431 build-V1.0.5713.21100 TSQLT-succesful-build-64 TSQLT-succesful-build-61 TSQLT-succesful-build-54 TSQLT-succesful-build-50 TSQLT-succesful-build-48 TSQLT-succesful-build-47 TSQLT-succesful-build-36
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.
Build replaced " with actual " Mar 22, 2018
Build_Output Different changes to make the tSQLt tests run in Azure. (not complete) Jan 25, 2016
Examples Fixed bug in example code. Thanks Dan Forbes. (6f58ffb#commitcomment-… Mar 11, 2016
Experiments Upgraded project to SSMS2014 Nov 24, 2014
OtherFiles No commit message Aug 22, 2015
PADGen/sqlitynet added PAD file and supporting PAD stuff Jun 14, 2010
Snippets tSQLt.RunNew allows to run all test classes created since the last ex… Jan 23, 2016
Source SpyProcedure (and also tSQLt.Private_RenameObjectToUniqueName) can no… Feb 25, 2016
TestUtil more work on tSQLt.InstallExternalAccessKey Dec 28, 2015
Tests.2008 moved AssertStringInTests to 2008 folder Nov 11, 2015
Tests.2012 No commit message Jan 3, 2015
Tests.2014 No commit message Jan 3, 2015
Tests.EXTERNAL_ACCESS tSQLt.RunNew allows to run all test classes created since the last ex… Jan 23, 2016
Tests.EXTERNAL_ACCESS_KEY_EXISTS Fixed fragile test: Private_InitTests_EAKE.[test Private_Init fails i… Jan 29, 2016
Tests.SA added tSQLt.RemoveExternalAccessKey Jan 23, 2016
Tests SpyProcedure (and also tSQLt.Private_RenameObjectToUniqueName) can no… Feb 25, 2016
tSQLtCLR added CI(NoSigning) Build Configuration Jun 30, 2018
.gitignore more work on tSQLt.InstallExternalAccessKey Dec 28, 2015 Added license info to Aug 11, 2016
UpgradeLog.XML Upgraded project to SSMS2014 Nov 24, 2014
tSQLt.ssmssln Different changes to make the tSQLt tests run in Azure. (not complete) Jan 25, 2016


Download the latest version at

tSQLt is a unit testing framework for Microsoft SQL Server. It is compatible with SQL Server 2005 (service pack 2 required) and above on all editions.

tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests. tSQLt also provides the following features to make it easier to create and manage unit tests:

  • Tests are automatically run within transactions – this keeps tests independent and reduces any cleanup work you need
  • Tests can be grouped together within a schema – allowing you to organize your tests and use common setup methods
  • Output can be generated in plain text or XML – making it easier to integrate with a continuous integration tool

tSQLt is licensed under Apache 2.0 (