Answer 1

Function must return a value but in StoredProcedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereasProcedures can have input/output parameters . ... Functions can be called fromProcedure whereas Procedures cannot be called from Function.