Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between function and procedure?
- 41 Answers
- 109337 Views
- HCL, IBM, iGate, Infosys, TCS, Veritas, Wipro, I also Faced
- E-Mail Answers
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
Can we create user defined functions in qtp?
When should I use smart identification?
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?
I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?
How to save your test using quicktest professional?
What is expert view and keyword view?
how do i know how to use tools
What is meant by a Check Point in UFT? Also, explain the applicable Check Points.
For example you are checking bit map check point before coming to the results. How can you say it is passed? Or failed? Anyways?
How to analyzing test results using quicktest professional?
How do you check ticket cost and ticket number in flight application?
what is test scheduleling?
What is test object model in quicktest professional (qtp)?
What are the general steps involved in the data driven framework?
How to record application running on the Virtual machine?
