1.

Difference Between Stored Procedure And Trigger?

Answer»
  • we can call stored procedure explicitly.
  • but trigger is AUTOMATICALLY INVOKED when the action defined in trigger is done.

ex: create trigger after Insert on

  • this trigger invoked after we insert something on that table.
  • Stored procedure can't be INACTIVE but trigger can be Inactive.
  • 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.

ex: create trigger after Insert on


Discussion

No Comment Found

Related InterviewSolutions