Answer Posted / vijay

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 can not 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. 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 wont support deferred name resolution.

7.Stored procedure returns always integer value by default
zero. where as 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.

In qtp, explain what is crypt object

1102

---

Is it possible to merge two object repository files in qtp?

1234

---

Diff b/w test scenario's and test Procedures?

2175

---

hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?

3937

---

What is file database?

2231

---

Hi Friendss..., can any body help me.. 1. Tell me your achievements(Technically)..? 2. Tell me your strengths(Technically) and weakness(Technical)..? 3. Why are you looking for change..?

1870

---

describe some problems that u had with automating testing tool?

1855

---

How will you compare keyword and expert view?

983

---

iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?

2120

---

how to create flat file datasubmission in qtp

2495

---

Name the properties you would use for identifying a browser and page when using descriptive programming?

1068

---

Hi! My OTP script has several bitmap checkpoints included which I check in the test results xml file. The test is for SAP 4.7. I need to save these bitmaps to files or at least export them to the html file using the export function in the test results viewer. Could you please help me with this problem? Thank you in advance! Best regards, Peter

2705

---

What are test settings and global settings?

1169

---

How do you test DLL files using automation Tool QTP?

3286

---

If I change the property value at runtime is it effect is object repository?

1140

---