Difference between RETURN and OUTPUT in STORE PROCEDURE

RETURN variable can only return integers and that too, only one integer. It is not possible to return more than one value.

They are used to return SUCCESS and FAILURE.

OUTPUT variable, we can return more than one value and any datatype. They are used to return name, count, etc.