Wednesday, July 24, 2019

When you want to test a sproc but not edit a database...

Well, let's say your sproc is to be added to the database via a script in source control or via a Visual Studio database project. How can you experiment with the sproc in the end environment if you're not actually supposed to hand change things there? It was suggested to me yesterday that you may just run a select statement with the guts of the sproc against the database. That probably is a pretty good test.

No comments:

Post a Comment