1.Function must return a value but stored procedure it is optional.
(procedure can return 0 or n values)
2. Function can have only input parameter, procedure can have input/output parameter.
3. Function take one input parameter it is mandatory but stored procedure may take 0 to n input parameter.
4. Function can be called from procedure where as procedure can not be called from function.