Procedure can modify the state of Database but Function can not. Function can be called in query but Procedure can not.