Stored Procedures and stored function are the same, except
Stored function returns a value and a stored procedure does not.
Stored procedure returns a value and a stored function does not.
Stored function returns a value and a stored procedure may OR may not.
Stored procedure returns a value and a stored function may OR may not.