Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between function and procedure?
- 41 Answers
- 109251 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
Write a QTP script to enter a keyword in to Google search engine?
How to analyzing test results using quicktest professional?
How can I change object description or check point values in qtp?
wht type of User defined functions or Java Releated functions Do we write in VB scripting
Are Shared ORs read-only?
How will you find the current time of the remote machine using QTP script?
can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?
How to use the object spy in quicktest professional (qtp) 8.0 version?
Explain how to use QTP to check broken links on a page?
How can I import environment from a file on disk?
What is Associate Repository in QTP 9.2 ?
what are the challenges you have faced while testing web based application using the automation tools ?
requirement is for combo box your expected value is str= "Denver.Frankfurt.London.Los Angeles.Paris.Portland.San Francisco.Seattle.Sydney.Zurich" you must get the text in combo box and need to compare them how
How qtp identifies objects?
What is the difference in the global and action sheet in qtp?
