Difference between stored procedure and function.

Stored Procedure have pre-compiled execuction plan where as functions do not.

Functions are used for computations where as procedures are mainly used for performing business logic.

Functions can only have 'in' parameter where as SP can have both 'in' and 'out' parameters.

Function does not allow DML (insert, update, delete) queries on an object where as SP allows.

Functions can be used inline where as SP can't be.

Stored Procedure can retun more than one value at a time while funtion returns only one value at a time.

Functions MUST return a value, procedures need not be