Sunday, November 17, 2013

Difference between stored procedure and function

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.

.


No comments: