What is difference between function and procedure?
Answer Posted / sardar tariq
A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.
-Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter.
-Function can be called from SQL statements where as procedure can not be called from the sql statements.
-Functions are normally used for computations where as procedures are normally used for executing business logic.
-You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.
-nction returns 1 value only. Procedure can return multiple values (max 1024)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which scripting language used by quicktest professional (qtp)?
what is supply chain management?
I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.
Hi,All How to create a link in excel sheet using qtp
How to create Reusable and Multiple Actions?
How will internal and external links be validated and updated? how often?
How do you convert manual test cases to automated test cases?
how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?
images are dynamically changes how to compare two images with out using the bitmap
How to use setroproperty?
What is the use of Debug Viewer?
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
what is the hierarchy to use properties in descriptive programming