Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between function and procedure?
- 41 Answers
- 109428 Views
- HCL, IBM, iGate, Infosys, TCS, Veritas, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / priya.
Procedures v/s functions.
1.A function MUST return a value. A procedure can also
return value, but it is NOT MANDATORY for Procedure to
return a value.
2.A function can return only ONE value. A procedure can
return MULTIPLE values.
3.A function can be used with SELECT statements as like as
other in-build functions. But, a procedure cannot be used
with SELECT statements.
4.A function cannot be executed directly from SQL prompt
using EXEC command, but it is possible to execute directly
from SQL prompt using EXEC command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / priya
1.A function must return a value. A procedure can also
return value, but it is not mandatory for Procedure to
return a value.
2.A function can return only one value. A procedure can
return multiple values.
3.A function can be used with SELECT statements as like as
other in-build functions. But, a procedure cannot be used
with SELECT statements.
4.A function cannot be executed directly from SQL prompt
using EXEC command, but it is possible to execute directly
from SQL prompt using EXEC command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / savi
1.fumction should return a value
procedure may or not return a value
2.function computes a value
procedure performs an action
| Is This Answer Correct ? | 1 Yes | 3 No |
1.Function always return a single value but procedure may
return more than one value.
2.We can use functions in select statement but we can not
use procedure in select statement.
3.There is possible of recurssive functionlike max(min
(something)),but there is nothing like in procedure.
4.In function we use a return keyword but in procedure no
return keyword is used.
| Is This Answer Correct ? | 8 Yes | 11 No |
Answer / abhishek khare
1.Funcan can return a valur but not procedure
2.Function can accept only one parameter IN but procedure
can take IN or OUT or both parameters.
3.Procedure follows only linear execution but not function.
| Is This Answer Correct ? | 13 Yes | 36 No |
Answer / siva
Fuction returns a value whereas procedure doesnt return any
value
if some function calling is dere den function switch over 2
d function definition part directly but procedure go from
top 2 down linearly
| Is This Answer Correct ? | 25 Yes | 82 No |
Answer / deepika
Action is a part of Function.
Function is a Like a Functional Test case.
Procedure is a process to perform the Different Actions
| Is This Answer Correct ? | 71 Yes | 136 No |
i have .xls,.txt,.doc files are there (together). i want find only .xls file among them? how can we write function?
How comfortable are you in VB scripting?
When using descriptive programming?
in my application,validation message has in japanise language.how to validate this message is appears properly or not
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...
How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.
In VSS, HoW the documents send to local folder? copy paste or any other? plz explain about VSS TOOL kit?
How to return a value from a fn, if it has more than one value how to return
how to capture data from images in QTP and produce them in excel sheet?
Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com
How can i check elements sorted in dorpdown using qtp..
In QTP if u got a defect , how to report to developer using Test director or Quality center .
WinRunner 
