Testing - What steps does a tester take in testing Stored Procedures?

What steps does a tester take in testing Stored Procedures?

- The tester needs to go through the requirement of the need of the stored procedure.

- Checks whether the indexes, joins, deletions, update are correct in comparison with tables mentioned in stored procedure. Ensure that the stored procedure is following the standards.

- Check the calling procedure name, calling parameters and expected responses for different sets of input parameters.

- Run the procedure with database client programs like TOAD or MySQL or Query Analyzer etc.

- Rerun the available procedures by sending different parameters, and check the results against expected values.

- Concluding to the process, automate the tests with WinRunner.

- The tester should call the stored procedure in the backend using the EXEC command. Here, if any parameters are required, they must be passed. Different values of parameters must be passed to confirm if the stored procedure is executed or not. On calling this command it must check and verify the nature and behavior of the database.
For e.g. if the stored procedure is written to populate some table, the table values must be checked.
Database Testing Interview Questions and Answers - Part 2
Database Testing Interview Questions - What is Database Testing?, How to test data loading in Database Testing?, What is trigger? How to check trigger is fired or not?, What is data driven testing?.....
What is functional testing?
Functional testing verifies that the end user gets what he wants from the application......
What are the differences between system and functional testing?
Functional testing involves testing of functional requirements as per the specification.......
Post your comment