A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.
Difference between a trigger and a stored procedure
1- when you create a trigger you have to identify event and action of your trigger but when you create s.p you don't identify event and action
2-trigger is run automatically if the event is occured but s.p don't run automatically but you have to run it manually
3- within a trigger you can call specific s.p but within a s.p you cann;t call atrigger
68 unique visitors
No comments:
Post a Comment