它引用的测试框架是 tSQLt,开源。 /user-guide/tsqlt-tutorial/ ALTER PROCEDURE [factorytest]. It often -- contains calls to methods such as tSQLt.FakeTable and tSQLt.SpyProcedure -- along with in an IF statement. -- Available Asserts: tSQLt.AssertEquals, tSQLt.AssertEqualsString, tSQLt.AssertEqualsTable in an IF statement. -- Available Asserts: tSQLt.AssertEquals, tSQLt.AssertEqualsString, tSQLt.AssertEqualsTable
该工具基于开源的 tSQLt 框架,因此 SQL 开发人员可以从在普通 T-SQL 中编写单元测试中受益。单元测试丰富的功能使得开发稳定可靠的代码成为可能,可以在单元级别进行适当的回归测试。