Question: what is the difference between a stored procedure and a trigger?
Answer: A stored procedure is a group of SQL statements that is compiled one time, and then can be executed many times. Triggers are named database objects that are implicitly fired when a triggering event occurs. ... A trigger is not called directly by a user, where as a stored procedure is directly called by a user.