I am a SQL Server DBA. To automate some of my daily tasks, I need to write stored procedures.
Creating functionality without testing does not make sense to me.
For creating and running my tests, I used the tSQLt Framework.
I had to create a database during the test. "CREATE DATABASE" is not permitted inside a multi-statement transaction, but all tests are automatically run inside a transaction within tSQLt Framework.
Naturally, I can set up a test database manually before running the test, but the test cannot depend on the environment in which it will be executed.
How should this be approached?
Asked by Meyssam Toluie
(227 rep)
Jun 20, 2022, 06:31 AM
Last activity: Nov 3, 2022, 09:25 AM
Last activity: Nov 3, 2022, 09:25 AM