SQL Server Unit Test Framework

Introduction

SQL-Unit is a unit testing framework for SQL Server (i.e. T-SQL).

Example Test

The following example shows a simple standalone test. T-SQL doesn't support attributes and so we have to annotate the name instead with a string. In SQL-Unit the form "_@attrib@_" pair should be considered synonmous with "[attrib]" in NUnit; hence the attribute "_@Test@_" defines a test.

 create procedure test._@Test@_Example
 as
     declare @actual varchar(100) = '42';

     exec ssunit.AssertStringEqualTo '42', @actual;
 go

Note:

This documentation was generated directly from the SQL-Unit T-SQL source code using Doxygen and the sql2doxygen input filter. See http://www.chrisoldwood.com