What is difference between function and procedure?
Answer Posted / kamal pratap singh
Difference between Functions and Stored Procedure:
1. Function always return value, but procedure may return
value or not.
2. Function return only one value, but procedure return one
value or more than one value.
3. In Function, we can insert a value through parameter
passing like IN. but in procedure, we can insert value using
IN or get a value using OUT or both insert and get value
through single parameter using INOUT.
4. Function are used to perform computation, but procedures
are used to perform business logic.
5. Function are needed to compile when they are called, but
procedures are compiled only one time, so procedures are no
need to compile again. Because the procedure are in pre
compiled format.
6. Function can be called with SQL query but procedure can
not be used with SQl query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of recording modes in qtp? Which will be used when?
How to give a call to another action from one action?
What are the different types of qtp test assets and their extensions?
1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?
How do you configure QTP AND Test director?
What is ObjectParamater?
What is the quicktest professional (qtp) testing process?
Name the different types of recording modes?
What is an object repository?
How to handle dynamic objects in quicktest professional (qtp)?
Can we record using all the modes in a single script? Explanation with example is appreciated
Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.
any body plz send health care domain project to me with explanation any two modules on that project. mail_id: ranjith_99reddy@yahoo.co.in
What are the features and benefits of quick test pro (qtp 8.0)?
What are the key elements available in test result window?