Question: what is the difference between a trigger and a routine?
Answer: We can execute a stored procedure whenever we want with the help of the exec command, but a trigger can only be executed whenever an event (insert, delete, and update) is fired on the table on which the trigger is defined. ... Stored procedures can return values but a trigger cannot return a value.