1) Function must return a value.where as stored procedure it is optional.
2) Function cannot execute where as stored procedures will execute independently.
3) Function can be used in any where in select clause.we cannot use procedure.
4) Function must be used with schema where as proc schema optional.
.
2) Function cannot execute where as stored procedures will execute independently.
3) Function can be used in any where in select clause.we cannot use procedure.
4) Function must be used with schema where as proc schema optional.
.
No comments:
Post a Comment