Answer Posted / pranjal

Bot 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.

what frame work you are following?

1985

---

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

2147

---

Explain process of smart Identification in QTP?

1098

---

What is the difference between a Function and Procedure in QTP?

1262

---

What is QTP testing process?

1122

---

How to execute the WR Script through QTP? I have WinRunner script with initialization script, common scripts, GUI AND functions. I connected WR through QTP with "call to WinRunner" option but I am getting problem after connecting to WinRunner i.e. showing "Do you want to quit now" with 'yes' and 'No' message box

2364

---

In qtp, explain what is qrs file?

1118

---

What are the benefits of qtp?

1289

---

We stored into the objects OR and then write the scripting

2081

---

What are the different types of functions available in qtp and explain ?

1056

---

Can we create user defined functions in qtp?

1059

---

How to run a test using quicktest professional (qtp)?

1206

---

i have a doubt can anyone tell me where are scripts stored while using QTP.Tell me the exact procedure takes place in real time?like how we call scripts how to proceed after writing scripts?how scripts are executed etc?i heard some use Qc whether others dont use.so tell me whole procedure for both the things it will be a very big help.as i have interview i want to have whole idea on this.its very urgent.

1960

---

Key word driven framework

2229

---

Hi, How Accessibility checkpoint in QTP can be implemented in the test script?

2178

---