How to test stored procuders???/

Answer Posted / shilpa

You have two alternatives. One is to create a stored
procedure that executes the procedure under development. It
will call the procedure with every combination of input
parameters possible. The second is to use the command
window as a client, and call the procedures from there.
This re-routes the server's error messages to the command
line, where you can trap them to a file and read them
outside Query Analyzer.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what the main advantages of statement coverage metric of software testing are?

550


During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?

690


What the main advantages of statement coverage metric of software testing are?

558


Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?

1795


What would you say to your boss if he?s crazy about an idea, but you think it stinks?

2097






i am fresher in manual testing.how to do database testing as a manual tester.suggest me some answers,so that i will have a clear idea adout database testing.

1905


wat r d schedules for testing?

2054


Describe your ideal working environment.

2390


What is api (application programming interface)?

615


What is test tools?

673


What is parallel/audit testing?

641


What is oo function testing?

602


Explain test procedure?

644


Explain what test plan is? What is the information that should be covered in test plan?

597


What are the advantages of SCSI compared to ATA or IDE ?

1420