Difference Between Stored Procedure and Functions Sql

Stored Procedure and Functions   1. Function Must Return Value    For Stored Procedure it's Not Must to return value it's optional  2. Stored Procedures are pre-compile objects which are compiled for  first time and its compiled format is saved which executes (compiled code) whenever it is called  But Function is compiled and executed...