---
title: "What are the different modes of firing triggers?"  
description: "What are the different modes of firing triggers?"  
author: "Sumit Kesarwani"  
published: 2013-06-15  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/1781/what-are-the-different-modes-of-firing-triggers  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What are the different modes of firing triggers?

**After Trigger:** An AFTER trigger fires after SQL Server completes all actions successfully.

\

Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire.

## Answers

### Answer by Sumit Kesarwani

**After Trigger:** An AFTER trigger fires after SQL Server completes all actions successfully.

\

Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire.


---

Original Source: https://www.mindstick.com/interview/1781/what-are-the-different-modes-of-firing-triggers

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