Wednesday, November 30, 2011

Difference between Trigger and Procedure


Triggers
Stored Procedures
In trigger no need to execute manually. Triggers will be fired automatically.
Triggers that run implicitly when an INSERT, UPDATE, or DELETE statement is issued against the associated table.
Where as in procedure we need to execute manually.

No comments:

Post a Comment