Function:
It is one among the fundamental thought in the computer programming. It is used to calculate something from a given input. Hence it got its name from Mathematics. Function can be either user defined or predefined. The function program has a block of code that performs some specific tasks or functions.
Procedure:
In programming a particular set of instructions or commands along known as a procedure. Counting on the programming language it is known as as procedure, subroutine, function or a subprogram.
Difference between Function and Procedure:
S.NO | Function | Procedure |
---|---|---|
1. | A function deals with as an expression. | Whereas a procedure does not deal with as an expression. |
2. | Function is used to calculate something from a given input. Hence it got its name from Mathematics. | While procedure is the set of commands, which are executed in a order. |
3. | The function can be called by a procedure. | But a procedure can not be called by a function. |
4. | In sql, inside the function we can not use the DML(Data manipulation language) commands such as Insert, Delete, Update. | Here, in sql, inside the procedure we can use DML commands. |
5. | Functions can be called through sql queries. | However, the procedure can’t be called through a sql query. |
6. | Each time functions are compiled when they are called. | Whereas, procedures are compiled only once and can be called again and again as needed without being compiled each time. |
7. | The return statement of a function returns the control and function’s result value to the calling program. | While the return statement of the procedure returns control to the calling program, it can not return the result value. |
8. | Function doesn’t support try-catch blocks. | While it supports try-catch blocks. |
9. | Function can be operated in the SELECT statement. | While it can’t be operated in the SELECT statement. |
10. | Function does not support explicit transaction handles. | While procedure supports explicit transaction handles. |
Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.