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.
0 comments:
Post a Comment