What is the difference between stored procedure & function?
devquora
Posted On: Jan 04, 2021
| Function | Stored Procedure |
|---|---|
| (1) Function should return a value. | Stored procedure may or may not return a value. |
| (2) Function should declared by using fun keyword. | Stored Procedure may not required fun keyword. |
| (3) Functions can have only input parameters. | Procedures can have input or output parameters. |
| (4) Functions can be called from Procedure. | Procedures cannot be called from a Function.. |
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Data Structure Interview Questions
What is meant by Object Oriented Programming – OOP?
Object-oriented programming (OOP) is a computer programming technique that organizes software design around data, or objects, rather than functions and logic. An object can be defined as a data field ...
Data Structure Interview Questions
What is meant by Structural Programming?
Structured Programming can be defined as a programming Approach in which the program is made as a single structure. Lines or blocks of codes are written and executed in a sequential manner such as one...
Data Structure Interview Questions
What is meant by Class?
A class is the most important part of object-oriented programming which is used for the purpose of creating objects. It is defined as the template of similar types of objects consists of a declaration...