Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between function and procedure?
- 41 Answers
- 107672 Views
- HCL, IBM, iGate, Infosys, TCS, Veritas, Wipro, I also Faced
- E-Mail Answers
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
is there any addin for remedy user application
How many tabs are available to view your test in a test pane and what are they?
what could go wrong with test automation?
Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.
What is regular expression?
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?
wht is Manual Testing Frame work. Pls anybody can give appropriate answers
what are the utilities and drivers
what is object and child object.. explain ..if possible give some example for better understanding ..
Where we can use the analog mode and where we can use the low – level mode?
How may types of defects identify application or your currently working application?pls give me answer..
How many add-ins comes by default with quicktest professional?
How many ways we can parameterize data in quicktest professional (qtp)?
Explain how you can replace string in qtp?
Explain QTP using different development techniques ?
