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.
0 comments:
Post a Comment