A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.A database trigger is a stored procedure that is invoked automatically when a predefined event occurs.Database triggers enable DBA's (Data Base Administrators) to create additional relationships between separate databases.A trigger is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. It is a database object which is bound to a table and is executed automatically.
For example, the modification of a record in one database could trigger the modification of a record in a second database.
SQL trigger is an SQL statements or a set of SQL statements which is stored to be activated or fired when an event associating with a database table occurs. The event can be any event including insert, update and delete.
Liked By
Write Answer
What is the concept of Trigger in MSSQLServer?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
10-Nov-2010Pushpendra Singh
09-Nov-2010