Answer / 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.

Answer / prajakta

Smuti, Very well done. I also feel and verified the same. Thanks for clarifying these things. :)

Answer / dasith

Function Always returns a value,
Procedure may/may not return a value,

:Execution of function & procedure depend on
number of lines of code in each, other than that
execution time is almost the same:

Answer / diya

a named piece of code developed to perform specific task is called function..

Answer / santhosh kandula

1.Function can return a value but procedure may or may not.

2.function can take input valuesand return the result where
as procedure can take the input and output values and
doesn't return any value, it will store the result.

3.We can perform transactional operations on fuctions like
insert,update,etc,... where as in procedure we just call
the with the procedure name.

4.Through procedures we store images where as through
fuctins it's not possible

Answer / madhu babu

1.function must always return a value.
2.it is return's only one value.
BUT
1.procedure may (or) may not return a value.
2.it is return's one (or) more values.

Answer / genious

The main difference between function and procedure:

1. The spelling is totally different.
2. Function start with "F" but proccedure starts with "P".
3. Function means a place or event where people enjoy by
taking differnt types of actives, those activites known as
Proceedure.
examples:- such as Marriage is an event but all activities
after marriage are proccedure.you all know what type of
activities taken place at night or you can also do in day
also.

Answer / dhruvit

the function return value
the procedure return or may not return value..
we can not call function in sql statements....

Answer / sardar tariq

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.
-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.
-Function can be called from SQL statements where as procedure can not be called from the sql statements.
-Functions are normally used for computations where as procedures are normally used for executing business logic.
-You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.
-nction returns 1 value only. Procedure can return multiple values (max 1024)

Answer / anonymus

Answer Number 8 Is exactly correct

suppose i can done the project , that project have 4 modules in that one module they have many links(web pages).in that time i can say i can work on some links? or total module?

4 Answers  

Hi..friends can anybody write the script for this question... Am having some 20 nos of links in a web application, i want to click some 5,13 & 17th links. So please....can anybody give the answer....??? -->Hani<--

4 Answers  

how u track bugs using Test director in manual testing.

2 Answers   Accenture, FCG,

I have recorded a test using qtp to download a file in an application. Code: Browser("MFA Work Queue Manager").Page("MFA Work Queue Manager").Link("Rules Maintenance").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebEdit("txtSearch").Set "PmtType" Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Search").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Export").Click Browser("MFA Work Queue Manager").Dialog("File Download").WinButton("Save").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").Sync Dialog("Save As").WinButton("Save").Click Dialog("Save As_2").WinButton("Yes").Click Problem: When running this test it gives an error at line no. 5 as Save button object is not identified by it's parent object. This code I ran 4 times after recording at it was working fine but 5th time onwords, it starts giving me the above problem. I used exist property option, Check Property option but none of this changes work at all. Kindly help...

1 Answers   Bank Of America,

Why do we use breakpoints in QTP?

0 Answers  

How do we Access, retriew and edit the runtime objects in Automation Testing using QTP

3 Answers   IBM,

Hello Everyone, In QTP we have one option Data Driver wizard that comes in Tools -> Data Driver. so, please tell me abtout the use of Add Value and Parameterize options available in Data Driver wizard. And also the concept of value, constants, Parameterized displayed in the wizard. Please explain by giving the example. Thanks in advance, Gaytri

2 Answers  

I have faced one issues while doing test in QTP. I have described the scenario below. 1. I have to test web application.In that i want to give input of drop down values in the application. 2. Suppose Drop down has 5 value "A,B,C,D,E".I would like to give value from data table of QTP. 3. I have changed the drop down value as variable in Keyword view and given values in data table "A,B,C,D,E" as one below one. 4. While i am running the script it could not identify the drop down value which is in Data Table.It shows message. How to make value identify by QTP?

1 Answers  

what is the difference between ClassName and class in QTP?

3 Answers  

how to know no.of mails in our g mail by using vb-script

0 Answers   HP, Thinking Hats,

How to create frame work for qtp?

1 Answers   Bank Of America, Polaris,

What is object state in trigger events,in recovery scenario.write a script to handle this.

0 Answers