Trigger Vs. Stored Procedure

Differences:

  1. 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.
  2. SP can pass the parameters which is not a case with Triggers.
  3. While creating a Trigger triggering event and action has to be specified which isn’t a case with SP.
  4. A Trigger can call the specific SP in it but the reverse is not true.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s