Srinivas

• May 17th, 2006

 

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.

Srinivas

Swisswin

R.Venkata Ramanujam

 Profile Answers by R.Venkata Ramanujam 

• May 17th, 2006

 

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.

In SQL server we r using

exec {procedure Name} input1,input2..

Venki

• Oct 25th, 2006

 

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

rkaur

 Profile Answers by rkaur 

• Oct 11th, 2007

 

Hi
Thanks for the above info...but no body has told the steps for testing stored procedures....I would appreciate a quick reply...
Thnx