- Actually trigger in action which is performed automatically before or after a event occur and stored procedure is a procedure which is executed when the it is called. Stored procedure is module.
- SP can pass the parameters which is not a case with Triggers.
- While creating a Trigger triggering event and action has to be specified which isn’t a case with SP.
- A Trigger can call the specific SP in it but the reverse is not true.