Answer Posted / gunesh

1.Function is mainly used in the case where it must return
a value. Where as a procedure may or may not return a value
or may return more than one value using the OUT parameter.
2.Function can be called from sql statements where as
procedure cannot be called from the sql statements.
3.Functions are normally used for computations where as
procedures are normally used for executing business logic.
4.You can have DML (insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL
Query.
5.A Function returns 1 value only. Procedure can return
multiple values (max 1024).
6.Stored Procedure: supports deferred name resolution.
Example while writing a stored procedure that uses table
named tabl1 and tabl2 etc...But actually not exists in
database is allowed only in during creation but runtime
throws error Function won’t support deferred name
resolution.
7.Stored procedure returns always integer value by default
zero. whereas function return type could be scalar or table
or table values
8.Stored procedure is precompiled execution plan where as
functions are not.
9.A procedure may modify an object where a function can
only return a value The RETURN statement immediately
completes the execution of a subprogram and returns control
to the caller.

What is QTP’s model for test creation?

1081

---

how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page

2247

---

1.explain end to end process of qc,2.how many tabs are in qc9.0,qc10.0 3.what is review, how many reviews are following in aproject 4.how will you get the requirements 5.why do we choose testing 6.how to export tc's and requirements to qc through add-ins

1897

---

Did QTP prove efficient for your project? Yes or No, explain?

6532

---

What are advantages of test automation?

1085

---

What is the syntax to call one action in another?

974

---

what is the hierarchy to use properties in descriptive programming

1929

---

What is throw object?

2274

---

If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?

5172

---

What is a programmatic description?

1048

---

Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

2150

---

What is 'sleep' in sync point?

1043

---

explain how to write vb script in qtp?when will you write own script?

2239

---

What are the steps involved in recovery scenario wizard?

929

---

Why to use descriptive programming?

941

---