Difference between Store Procedure and Trigger?

Difference between Store Procedure and Trigger
-------------------------------------------------------------
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.

No comments:

Post a Comment

Please Provide your feedback here