Skip to content

tSQLt - Database Unit Testing for SQL Server

Database Unit Testing for SQL Server

  • Home
  • Docs
    • Documents
    • Quick Start
    • Articles
  • Training
  • Downloads

How to get more out of tSQLt

 

Integrating tSQLt with CruiseControl

How to integrate tSQLt test results with the popular continuous integration tool, CruiseControl.
Read more

Supporting a database refactoring with tests and views

How a change to the database structure does not have to halt development and can be appropriately unit tested.
Read more

Using the tSQLt ResultSetFilter

How to retrieve a single result set from a statement which produces multiple result sets.

Read more

Refactoring SQL Server code

A look at how to improve the quality of SQL Server code using a valid set of tSQLt tests.
Read more

Testing COALESCE with tSQLt

Learn how to use tSQLt to test COALESCE queries.
Read more

Adding PK exceptions to SQLCop tests

How to enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
Read more

tSQLt and the INSERT EXEC problem

A proposed solution to the INSERT EXEC problem in tSQLt.
Read more

Checking table metadata with tSQLt

How to use the AssertResultSetsHaveSameMetaData method from the tSQLt framework to enforce APIs.
Read more

Testing simple calculations and UDFs with tSQLt

A basic look at how to test user-defined functions with the tSQLt framework.
Read more

Prevent sp_ procedures with SQLCop

Using SQLCop with tSQLt to check for check for sp_ named procedures.
Read more

Navigation

  • Join the conversation
  • Downloads
  • New Logo
  • Sponsors & Contributors
  • Release Notes
  • Articles
  • Training
  • How to get more out of tSQLt
  • Why you should use the tSQLt framework
  • Why you should unit test SQL Server Code
  • Full user guide
  • Documents
    • Quick Start
    • tSQLt Tutorial
    • tSQLt Keyboard Shortcuts
    • Test Creation and Execution
      • NewTestClass
      • DropClass
      • RunAll
      • Run
      • RenameClass
    • Assertions
      • AssertEmptyTable
      • AssertNotEquals
      • AssertObjectDoesNotExist
      • AssertEqualsTableSchema
      • AssertEquals
      • AssertEqualsString
      • AssertEqualsTable
      • AssertObjectExists
      • AssertResultSetsHaveSameMetaData
      • Fail
      • AssertLike
    • Expectations
      • ExpectException
      • ExpectNoException
    • Isolating Dependencies
      • FakeFunction
      • RemoveObjectIfExists
      • ApplyConstraint
      • SpyProcedure
      • FakeTable
      • ApplyTrigger
      • RemoveObject

Links

  • tSQLt on GitHub
  • tSQLt Mailing List
  • twitter hashtag (#tsqlt)
  • tSQLt tag on stackoverflow.com
  • SQL Server Community on Slack (#tsqlt)
  • #tSQLtLive on YouTube

Sponsors

sqlity.net
redgate.com

A sqlity.net llc Web Property. | ©2010 - 2020, All Rights Reserved. | Privacy Policy | Terms of Use