---
title: "What is the difference between Triggers and Stored Procedure?"  
description: "What is the difference between Triggers and Stored Procedure?"  
author: "Sumit Kesarwani"  
published: 2013-12-22  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/1851/what-is-the-difference-between-triggers-and-stored-procedure  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What is the difference between Triggers and Stored Procedure?

Stored Procedures are called by the programmer wherever it wants to fire but triggers fired automatically when insert, delete, update occurs. And triggers can be implemented to tables & views only where as stored procedure used in the database independently.

## Answers

### Answer by Sumit Kesarwani

Stored Procedures are called by the programmer wherever it wants to fire but triggers fired automatically when insert, delete, update occurs. And triggers can be implemented to tables & views only where as stored procedure used in the database independently.


---

Original Source: https://www.mindstick.com/interview/1851/what-is-the-difference-between-triggers-and-stored-procedure

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