Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is difference between function and procedure?

Answers were Sorted based on User's Feedback



What is difference between function and procedure?..

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.

Is This Answer Correct ?    3 Yes 0 No

What is difference between function and procedure?..

Answer / prajakta

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

Is This Answer Correct ?    3 Yes 0 No

What is difference between function and procedure?..

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:

Is This Answer Correct ?    2 Yes 0 No

What is difference between function and procedure?..

Answer / diya

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

Is This Answer Correct ?    2 Yes 1 No

What is difference between function and procedure?..

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

Is This Answer Correct ?    1 Yes 0 No

What is difference between function and procedure?..

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.

Is This Answer Correct ?    1 Yes 0 No

What is difference between function and procedure?..

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.

Is This Answer Correct ?    1 Yes 0 No

What is difference between function and procedure?..

Answer / dhruvit

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

Is This Answer Correct ?    1 Yes 0 No

What is difference between function and procedure?..

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)

Is This Answer Correct ?    1 Yes 0 No

What is difference between function and procedure?..

Answer / anonymus

Answer Number 8 Is exactly correct

Is This Answer Correct ?    1 Yes 0 No

Post New Answer



More QTP Interview Questions

Is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?

1 Answers  


How to covert a String to an integer?

5 Answers  


How can you pass value one action to another action?

0 Answers  


In a QTP project lets say there are 100+ function library and incorrectly we have duplicate some function in multiple libraries. How to find those duplicate functions and remove them?

1 Answers  


What is log file?How to write log file code?

2 Answers   Apps Lab, Value Labs,






How did you achieve reusability via QTP?

1 Answers  


tell me about if in the interview what i should tell about pharma application,what r the pharma application concepts,i need pharma application testing features

0 Answers  


What is an object repository?

0 Answers  


1.How to find in which row or column,string "Hyderabad" exist in excel sheet? 2.How to find how many times character "a" repeated in a given string "Koteswararao"

6 Answers   Ness Technologies,


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

0 Answers   Synechron,


I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .

0 Answers   Livetek,


What is the another extension name of library file. If that is exist than what's the difference between them.

2 Answers   Synechron,






Categories