Home > DeveloperSection > Interviews > What is the concept of Trigger in MSSQLServer?

Posted on    October-15-2010 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 2 Answer(s)
  1201  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Points:1205
Posted on    November-09-2010 1:00 AM

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.

Chris S
Chris S

Total Post:23

Points:115
Posted on    November-10-2010 1:00 AM

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.

Modified On Mar-21-2016 06:34:05 AM

Don't want to miss updates? Please click the below button!

Follow MindStick