What is difference between function and procedure?
- 41 Answers
- 97080 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 the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
Presently i am working on QTP 8.2 Version,i want to know features in 9.2 version, because i have not sufficient time to put the effort on the 9.2 version
Is it possible to change the property value at runtime? How it is possible?
what is object and child object.. explain ..if possible give some example for better understanding ..
Whether qtp 9.0 supports Test director8.0
wht type of User defined functions or Java Releated functions do we write in VB scripting
How do you check ticket cost and ticket number in flight application?
Without using gui map editor we can recognize the application in winrunner ?
How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined
how to know no.of mails in our g mail by using vb-script
what you mean by artifact,milestone...
How to import a test case present in ".xls" file to TD under a Test set?
How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one
What are the things(properties, and other details) will be recorded while recording an object using normal recording?
I want two test two agents login for the flight website. Here is the scenario: I want to go through 1-3 rows for one user login and other user login I want to go though 3-5 rows. How would you set this up in qtp. Thank You
