testing of Stored Procedure
-
Hey all, Could anyone help me in testing a stored procedure for a report? what could be the outcomes for that?
-
Hey all, Could anyone help me in testing a stored procedure for a report? what could be the outcomes for that?
To test a stored procedure ensure you have a known set of inputs. That includes the contents of the tables as well as the parameters. Run the stored procedure and ensure the output is as you expect. There isn't a lot more to it than that. The difficulty is ensuring a consistent input set so you are not tracking down false failures in the stored procedure when the test data is at fault.
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website