A trigger is executed every time a data-modification operation occurs (i.e., insert, update or delete). A stored procedure is a set of T-SQL statements combined to perform a single task of several tasks. It’s basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.