Stack Overflow
Stack Overflow

Questions tagged [tsqlunit]

TSQLUnit is a testing framework to write tests for applications written in Transact-SQL. It follows the tradition of the "xUnit" framework that is available for almost all programming languages.

TSQLUnit is a testing framework to write tests for applications written in Transact-SQL. It follows the tradition of the xUnit framework that is available for almost all programming languages.

https://sourceforge.net/apps/trac/tsqlunit/

4 questions
5
votes
0 answers

Build error for DB unit test project in VS2019

I recently got a brand new workstation and installed VS2019 on it. Previously, I was on VS2017 and working with db unit test project. Now when building our SQL Server database unit test project in VS2019, I got the following error: The primary…
Magendran V
  • 1,411
  • 3
  • 19
  • 33
5
votes
2 answers

How do I mock/fake a RaiseError with in a StoredProcedure

This is my first day with tsqlt so you can expect some vague statements. I am trying to test a storedProcedure which has a Try Catch Block but the actual statements in test are insert and update command. now I want to test if in case there was an…
Muds
  • 4,006
  • 5
  • 31
  • 53
0
votes
1 answer

SQL Unit Testing with TSQLUNIT

I noticed something weird while unit testing an update/insert stored procedure using TSQLUNIT on SQL Server 2012. when I call Exec tsu_RunTests, my test procedure runs but with unexpected behaviour. the line in the code that calls my original stored…
Kobojunkie
  • 6,375
  • 31
  • 109
  • 164
0
votes
2 answers

TSQLUnit for SQL Server 2000?

I need a testing framework for SQL Server 2000 (yeah, I know). I would ideally use tSQLt with Red Gate Test but it does not work on SQL 2000 because it requires CLR (among other issues). A lot of the info out there suggests TSQLUnit is (was?)…
onedaywhen
  • 55,269
  • 12
  • 100
  • 138