Difference between Function and Stored Procedure

Difference between Function and Stored Procedure

Function

ü  It’s return only value which is mandatory.

ü  Can have only input parameters.

ü  Try-catch block cannot be used in a function.

ü  We can’t use transaction management in function.

ü  Function can be called in stored procedure

Stored Procedure

ü  It’s return zero or n values.

ü  Can have input/output parameters.

ü  Procedure cannot  be called from Function

ü  Exception can be handle by try-catch block.

ü  Transaction management can be used in Stored Procedure.