What are differences between function and
stored procedure?
Ans:
1)
Function
returns only one value but procedure returns one or more than one value.
2)
Function can be utilized in select statements but that is
not possible in procedure.
3)
Procedure can have an input and output parameters but
function has only input parameters only.
4)
Exceptions can be handled by try catch block in
procedures but that is not possible in function.
No comments:
Post a Comment