Difference between a function and a stored procedure in SQL

The main difference is a function cannot run insert , update or delete statements, a stored procedure can.

Functions can return a single value or a result set, like a stored procedure.