WHAT IS THE CONCEPT OF TRIGGER IN MSSQLSERVER?

Sanjay Sharma

Total Post:42

Points:210
Posted by  Sanjay Sharma
 1435  View(s)
Ratings:
Rate this:
  1. Pushpendra Singh

    Post:241

    Points:1205
    What is the concept of Trigger in MSSQLServer?

    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.

  1. Chris S

    Post:23

    Points:115
    What is the concept of Trigger in MSSQLServer?

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!