Articles

 
  • Creating and Running Test Cases in tSQLt The following tutorial gives a brief introduction to creating test cases and a variety of methods to execute them. Before using any of the tSQLt procedures however, you must download them and install them in your database. Creating Test Cases Test cases in tSQLt are grouped into test classes. A test class is essentially a SQL schema ...
  • Database Test Driven Development UPDATE: This article is based on extensions written for tsqlunit. Those extensions are not any longer supported. However, if you are still using SQL Server 2000 you might want to check them out as tSQLt is not compatible with SQL Server 2000. Besides of these points, this article is still a worthwhile introduction to Database ...
  • Integrating tSQLt with Cruise Control tSQLt test cases can be executed and included in the results of your continuous integration build. This section describes how to integrate tSQLt test results with the popular continuous integration tool,¬†CruiseControl. CruiseControl executes your build script on a schedule or when code is checked-in to the version control repository. It reports build errors automatically and can ...
  • Refactoring Example: Office Hours Supporting a Database Refactoring with Tests and Views As we develop a database application, we often realize that decisions made early on regarding normalization need to be changed. A recent post on the Agile Databases mailing list illustrates this need. Let’s suppose we have an application that stores the office hours that employees make ...
  • Using tSQLt.ResultSetFilter Overview The ResultSetFilter procedure provides the ability to retrieve a single result set from a statement which produces multiple result sets. SQL Server comes installed with many stored procedures which return multiple result sets, such as sp_monitor, sp_spaceused and sp_help (when used with certain parameters). It is also common that developers will ...
0 comments