What is Difference between Function and Store Procedure in sqlserver?

Function

1. Function must be returning the result set values. Or single column values
2. Function only input parameters
3. Function can use in Sql Statement Having/Where/Select sections anywhere.
4. Function can return values so we can use joins in any other tables
5. Function can call from procedure

Store Procedure

1.Store procedure no need to return values.
2. Store procedure allow input/output parameters
3.Store procedure not allow where/Having/select sections anywhere in Sql statements
4.Procedure can’t call from function