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