Difference between procedures and functions

• When the parameter is passed into the procedure; it does not return any value whereas a function always returns a value.

• One of the major differences in both of them is that procedures are not used in databases whereas functions play an important role in returning values from a database.

• Procedures are capable of returning multiple values and the functions are able to return limited values.

Function must return a value, but in Stored Procedure it is optional(Procedure can return zero or n values). Function takes one input parameter it is mandatory ,but Stored Procedure may take 0 to n input parameters.. Functions can be called from Procedure whereasProcedures cannot be called from Function.
1 5 1