Test engineer needs to follow some steps to test the Stored Procedures :
* First, the test engineer should understand the requirement and also the purpose of a particular Stored Procedure.
* Next, verify whether all the indexes, joins, updates, deletions are precise in comparison with the tables mentioned in the Stored Procedure and also make sure that the Stored Procedure is in the common standard format, like comments, updated by, etc.
* Then, for different sets of input parameters, verify the procedure calling name, calling parameters, and expected responses.
* Manually, run the procedure with database client programs like TOAD, MySQL, or Query Analyzer.
* To verify results against expected values, re-run the procedure by giving different parameters.
* Finally, automate the tests with QTP.
