What is the concept of Trigger in MSSQLServer?

Question

Anonymous User · Answer

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.

Pushpendra Singh · Answer

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.

interview

What is the concept of Trigger in MSSQLServer?

Can you answer this question?

2 Answers