Answer Posted / veera

1) Stored procedure are compiled for first time and compiled
format is saved and executes compiled code when ever it is
called. But function is compiled and executed every time it
is called.

2) Function must return a value but in stored procedure it
is optional.

3) Function takes one input parameter it is mandatory but
stored procedure may take o to n input parameters.

4) Functions can be called from select statement, but stored
procedures can not be called from select statement.

5) We can build logic in functions and we can even break
complex logic in to methods.

6) We can use try catch statements in stored procedures but
in functions we can not use.

7) We can not use insert,delete,update and create statements
in functions but in stored procedures we can use those
statements.

8 ) Functions can have only input parameters but stored
procedure can have input and out put parameters


Thanks and Regards,
VEERA

In QA Testing when do you use Loadrunner vs QTP? What are the main differences between those two tools? Explain the purpose with real world scenario examples...In advance thank you!!!

2909

---

whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

2133

---

How to replay a script in qtp?

1087

---

• What type of testing questions will be asked for 2+ yrs exp people in interview?

1681

---

Write a QTP script to enter a keyword in to Google search engine?

1056

---

what is impact analysis on regression testing?

2475

---

i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.

2013

---

hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?

2018

---

Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?

2376

---

Tell me about your project? please help me how to tell about insurance project

1991

---

Explain in brief about the quicktest professional (qtp) automation object model?

975

---

How many types of run modes are there in qtp?

1034

---

Where you are storing your script?

1082

---

How do I get the QTP scripts result in xml format by using vb script function?

2271

---

Which functionalities of QTP used in banking project?

2441

---