How do I test stored procedure there in sql server 2000( Iam involved in software testing )?

Question:

Answer:
Um ... write the stored procedure, then execute it? That seems to be pretty obvious.

Just make a duplicate version of the same database and all its objects, if you're worried about destroying the DB if your procedure goes bad.

---

To test stored procedure, the the SP in Query Analyzer.

For example:

EXEC SP_Name Value1, Value2

---

More Questions & Answers...

Defination of human resource?

For which course i have to go so that i can have bright future and earn good salary?

I have recently join the army my job is Human Resources what are my chances of going to Iraq?

Business Analysis Question,help please?

Software Testing Institutes in Hyderabad?

Outsourcing Human Resources...?

Documents used in software testing?

Can a merchant press charges?