Answer and Explanation:
Stored Procedure : It is an object that is pre-compiled. It seems to be the initially compile as well as those files are saved. It executes that compilation file while this has been called.
Functions : Through, when the function is called it is compiled as well as executed.
The differences between the both is that -
- Stored Procedure return null, singular, or various values while Function only return one value at a time.
- Transactions cannot used in the function but it can be used in stored procedure.
- Functions may be named from such a stored procedure, but still not likewise.
- Stored procedures may have an input or output arguments, but the function still contain arguments for input.
- With the Academic Database situation, this is useful to use saved protocol anytime you choose to update / delete a participant, course, teachers, etc. Stored procedures are useful where the information or tables layout is to be altered.