how to test stored procedures in manually?

Answer Posted / janaki

hi sasidhar

depending on the project we will write testcases
for ex: in project class table is there
for that class table we have one stored procedure.

so we have to write the testcase like
input description:
"executing the stored procedure proce1 with input values
input data: (111,'abc',35)or take the input data from
database class table
expected results:the data shouble be inserted into class table

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between PEGA based web application testing versus web application testing?

4860


What is the limit for test steps?It should be 10/20/30etc

1688


Test approach to windows update?

1938


Hi friends, Im an MBA Finance, 2 yrs of exp workng in Investment com, + around 2 yrs of exp in Manual testing in Finane domain. Im looking for manual testing jobs but not getting any calls, Im worried is manual tesing in finance domain do have any good scopes in future or not. Plz provide me ur valuable suggestion,so tht I can best decision to retain in this platform(manual testing). or not

2086


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

2201


What is formal testing?

874


What is application programming interface (api)?

847


Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?

2308


what is JAVA TESTING? What Testers will do in JAVA Testing. Can any one Give suitable Ans Pls. it's urgent

1785


Any one please can u tell me what is composer? An interviewer asked me do u have experience in Composer? its urgent.

1819


In testing environment have you ever found any areas for improvement while you at work. (Please give some real life example).

1630


Relative to other technical groups in the company? Relative to your staff?

1683


what is the challenging position faced in the testing not in point of management point of view it must be in the point of while testing the application?

4419


what are the different methods to test a product in 'Japanese' language? NOTE:User is unable to perform basic functionalities while using the app..(copy, paste, text selection etc.)

1689


What are the interview question on insurance domain in manual testing

19565