Answer / swetha

There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

Answer / anand

3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005

DDL and LOGON are used to administrator related tasks

Answer / yugal

SQL Server 2008 includes three general types of triggers:

1)DML triggers
2)DDL triggers
3)Logon triggers.

Answer / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

Answer / balaji

which one is correct?
ISthis DML,DDL,CLR or Instead of trigger, after trigger

Answer / rajkumar v

SQLserver2000
There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

SQLserver2005

3 types:

1. DML,
2. DDL &
3. CLR

Answer / touhid

3

Answer / abcd

3 types:

1. DML,
2. DDL &
3. CLR (is it right?)

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

What are triggers in ms sql server?

0 Answers  

Simple example for difference between select and cursor in sql

1 Answers  

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

What is a heap?

0 Answers  

What is collation sensitivity?

0 Answers  

How to Run a Query on a Remote SQL Server?

2 Answers  

What is the difference between constraints and triggers?

9 Answers   Wipro,

What are “lock” hints?

0 Answers  

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

Define Joins?

0 Answers   HCL,