---
title: "What is the concept of Trigger in MSSQLServer?"  
description: "What is the concept of Trigger in MSSQLServer?"  
author: "Anonymous User"  
published: 2010-10-15  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/13/what-is-the-concept-of-trigger-in-mssqlserver  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 2 minutes  

---

# 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. \

## Answers

### Answer by Anonymous User

A trigger is a special kind of a store procedure that executes in response to certain action on the table like i**nsertion, 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.\

### Answer by Pushpendra Singh

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. \


---

Original Source: https://www.mindstick.com/interview/13/what-is-the-concept-of-trigger-in-mssqlserver

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.