3 ms·

I think GP meant that you can't/it's hard to test the stored procedures themselves. In this case if you mock the database calls you will not test the database l

I think GP meant that you can't/it's hard to test the stored procedures themselves. In this case if you mock the database calls you will not test the database logic.

ZenoArrow 9y ago
You can unit test stored procedures. For example, with T-SQL can use the open source unit testing framework tSQLt: http://tsqlt.org/ http://tsqlt.org/ tSQLt is used by the commercial SQL Test product from Red Gate if you wanted a more polished user experience: https://www.red-gate.com/products/sql-development/sql-test/index https://www.red-gate.com/products/sql-development/sql-test/i...