Difference between Store Procedure and Trigger?

Difference between Store Procedure and Trigger?

  1. We can call stored procedure explicitly.
  2. But trigger is automatically invoked when the action defined in trigger is done.      ex: create trigger after Insert on
  3. This trigger invoked after we insert something on that table.
  4. Stored procedure can't be inactive but trigger can be Inactive.
  5. Triggers are used to initiate a particular activity after fulfilling certain condition.It need to define and can be enable and disable according to need.

0 comments:

Post a Comment