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 .
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