Stored procedures are used to perform an action, while functions return a value.

• Stored procedures are precompiled and stored in the database for repeated use.

• Functions can be used in SQL statements to...read more

The function must return a value but in Stored Procedure it is optional