How many types of Triggers in SQL SERVER?

Posted by Rohit Kumar in Database | SQL Server on Dec 02, 2012

4
3845

Do you know the answer for this question? Post it below.

This Feature is Sponsored By

500+ c# and .NET interview questions and answer videos.

Posted by sonu singh on Dec 28, 2012

There are three action query types that you use in SQL which are INSERT, UPDATE and DELETE. So, there are three types of triggers... AFTER INSERT Trigger. AFTER UPDATE Trigger. AFTER DELETE Trigger. triggers are classified into two main types:- 1 After Triggers (For Triggers) 2 Instead Of Triggers

Posted by Praneet Rane on Mar 19, 2013

There are 2 main types of triggers: 1.After triggers (also known as For triggers. 2.Instead of triggers 1.After triggers further classified into : a.After Insert b.After Update c.After Delete. 2. Instead of triggers further classified into : a.Instead of Insert. b. Instead of Update. c. Instead of Delete.

Posted by Sriram Ramasamy on Jan 07, 2013

There are 2 types of triggers. They are 1. DML Triggers ---> a. After trigger b. Instead of trigger 2. DDL Triggers

Posted by Sriram Ramasamy on Jan 07, 2013

There are 2 types of triggers. They are 1. DML Triggers ---> a. After trigger b. Instead of trigger 2. DDL Triggers

Related Questions

PREMIUM SPONSORS

DynamicPDF Developer Components iPhone, Android & Web Development Services

TRENDING NOW

What is difference between C++ and C# Which is the first version of C# language. How to develop XNA Apps in Visual Studio 2012? How to Fetch Different Values in LINQ? How to Retrieve Column Names of a Table in SQL Server 2012? How to create Backup of Database in SQL Server 2012? How a table is truncating using LINQ How to import Data to Excel SpreadSheet in .NET How to enabled form validation in html5? How to Get Marquee Feature Without Marquee Tag in HTML5?

MOST LIKED QUESTIONS

Why do you want to leave your current company? In which situation(s), the use of "Delegate" is a good idea? Which namespaces are necessary to create a localized application? In which assembly MVC framework is defined ? How a table is truncating using LINQ Types of Polymorphism How to declares a two-dimensional array in C#? What is Polymorphism? How does VB.NET/C# achieve polymorphism? I have some dll that developed by ASP application,can i use reuse that dll to ASP.net application,Is it possible ,How Explain? In an application currently in production, one module of code is being modified. Is it necessary to re-test the whole application or is it enough to just test functionality associated with that module?

In Focus

Related Questions