Function can return at most one value at a time while 
procedure can return more than one value at a time You can 
use function within Sql Statement and you cannot use stored 
procedure with in Sql Statement

A Function is always returns a value using the return 
statement. A Procedure may return one or more values 
through parameters or may not return at all.

function can not have update,delete or insert statement but
Stored procedure can have