sp vs user defined function

A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.