Integrating tSQLt with CruiseControlHow to integrate tSQLt test results with the popular continuous integration tool, CruiseControl. |
|||
Supporting a database refactoring with tests and viewsHow a change to the database structure does not have to halt development and can be appropriately unit tested. |
|||
Using the tSQLt ResultSetFilterHow to retrieve a single result set from a statement which produces multiple result sets. |
|||
Refactoring SQL Server codeA look at how to improve the quality of SQL Server code using a valid set of tSQLt tests. |
|||
Testing COALESCE with tSQLtLearn how to use tSQLt to test COALESCE queries. |
|||
Adding PK exceptions to SQLCop testsHow to enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed. |
|||
tSQLt and the INSERT EXEC problemA proposed solution to the INSERT EXEC problem in tSQLt. |
|||
Checking table metadata with tSQLtHow to use the AssertResultSetsHaveSameMetaData method from the tSQLt framework to enforce APIs. |
|||
Testing simple calculations and UDFs with tSQLtA basic look at how to test user-defined functions with the tSQLt framework. |
|||
Prevent sp_ procedures with SQLCopUsing SQLCop with tSQLt to check for check for sp_ named procedures. |