RE: What steps does a tester take in testingStor...
In my view the tester has to go through the requirement as to why the particular stored procedure is written for? and check whether all the required indexes joins updates deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like comments updated by etc.
RE: What steps does a tester take in testingStor...
Dear Testers
Testing the Stored Procedures is the good one.we are passing the Input parameters and easily get the result(output) fast compare to testing the tough business logic in front end.
RE: What steps does a tester take in testingStor...
It is necessary to impliment error handling mechanism in stored procedures where in every system thrown error messages will be taken care off. Its testers job to check for error handling mechanism.Say for example: a variable is declared with varchar 30 and user tried to assign a value which is 40 size.....system will throw the error saying buffer too small or 'something like that.In the above case we should not leave SP or application using the SP in an unknown situation.--tahnxvenki
