What is difference between function and procedure?
Answer Posted / veera
1) Stored procedure are compiled for first time and compiled
format is saved and executes compiled code when ever it is
called. But function is compiled and executed every time it
is called.
2) Function must return a value but in stored procedure it
is optional.
3) Function takes one input parameter it is mandatory but
stored procedure may take o to n input parameters.
4) Functions can be called from select statement, but stored
procedures can not be called from select statement.
5) We can build logic in functions and we can even break
complex logic in to methods.
6) We can use try catch statements in stored procedures but
in functions we can not use.
7) We can not use insert,delete,update and create statements
in functions but in stored procedures we can use those
statements.
8 ) Functions can have only input parameters but stored
procedure can have input and out put parameters
Thanks and Regards,
VEERA
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When to use descriptive programming?
Can you list some technologies that support qtp?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
What is Associate Repository in QTP 9.2 ?
What are the different kinds of test steps?
Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji
How will you report the bug and explain the defect tracking sheet you handled?
Approach for Installation,comaptibility,system testing
Generic function to search for the unique link in webtable and click on it
What are the features of quick test pro(qtp)?
What are the five challenges you faced in QTP?
How software automation specialist enter steps in the Expert View?
Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com
How to modify object property in qtp ?
What is fragmentation and paging?