Share Blog

Saturday, March 22, 2014

WHAT IS DIFFRENCE BETWEEN FUNCTION And STORE PROCEDURE

1.Function Must Return a value But Store Procedure it is Optional can  Return 0 or n Values.
2.Function can have only Input Input parameter for it but Store Procedure Can have INPUT/OUTPUT Parameter.
3.Function take one(1) Input parameter it is mandatory but Store Procedure may take Zero(0) or n Input parameter.
4.Function can be Called From Procedure but Store Procedure can Not Called From Function.
5.Function can't Use TRY -CATCH block  but Store Procedure can Use TRY -CATCH block   .                                       

No comments:

Post a Comment