Answer Posted / santosh(ssit)

Both functions and procedures can return values. Apart from
this following are the differences

1) Functions are used for computations where as procedures
can be used for performing business logic

2) Functions MUST return a value, procedures need not be.

3) You can have DML(insert,update, delete) statements in a
function. But, you cannot call such a function in a SQL query..
eg: suppose, if u have a function that is updating a table..
you can't call that function in any sql query.
- select myFunction(field) from sometable; will throw error.

4) Function parameters are always IN, no OUT is possible

5) Function returns 1 value only. procedure can return
multiple values(max. 1024)

6) Stored Procedure :supports deffered name resoultion
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 wont support deffered name resolution.
Stored procedure returns always integer value by default
zero. where as function return type could be
scalar or table or table values(SQL Server).
Stored procedure is pre compiled exuction plan where as
functions are not.

7) A procedure may modifiy an object where a function can
only return a value.

When you open QTP, how many sheets you can see?

1079

---

What are the five challenges you faced in QTP?

3208

---

How many types of actions are there in quicktest professional (qtp)?

968

---

tell me abt a time when u had to go above &beyind the call of duty to get the job done

1938

---

Through array we can execute the testcase how ? give me example

1881

---

Hybrid framework supports Descriptive programming. Is it true?

1160

---

What are output values and why they are used ?

1070

---

In qtp is it possible to check broken links of a page?

1047

---

how will you check how many members visited the website www.infosys.com?

1915

---

The hybrid framework can be implemented for any application. Is it true?

1127

---

Explain the concept of object repository?

981

---

What r the different filters in defect in quality center

3761

---

if there is a web table of having row and colmns.a button is placed at 2nd row's 3rd column which is worked for both edit and delete..how to write script for the button to test both operation on the web table using desriptive programing.. plz help me on script wheather using getroproperty Q2)what is the command for taking valiue from a web table in qtp

25725

---

Discuss quicktest professional (qtp) environment?

1010

---

what is actually contain test report? can anybody post the test report

1980

---