Difference between function and stored procedure in Sql

Functions follow the computer-sciency definition in that they MUST return a value and cannot alter the data they receive as parameters (the arguments). Functions are not allowed to change anything, must have at least one parameter, and they must return a value. Stored procs do not have to have a parameter, can change database objects, and do not have to return a value.

 

Ref. here https://stackoverflow.com/questions/1179758/function-vs-stored-procedure-in-sql-server 

 

Here you see some more detais https://www.c-sharpcorner.com/UploadFile/996353/difference-between-stored-procedure-and-user-defined-functio/