Types of Triggers * DML(data manipulation language) triggers (SQL Se

How many types of TRIGGERS are there in MS SQL Server?

Question Posted / devipriyanka

8 Answers
31626 Views
CarrizalSoft Technologies, TCS, United Healthcare, I also Faced
E-Mail Answers

Answer Posted / 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)

Is This Answer Correct ?

13 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention what are the core components of ssrs?

330

What are the advantages to use stored procedures?

1179

What is the difference between coalesce() & isnull()?

1189

Is foreign key a primary key?

1177

Explain different types of self contained sub query?

1105

How can I get data from a database on another server?

1047

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

How many types of keys are there?

1074

What is recompile sql server?

1080

What do you mean by subquery?

1146

What is 'write-ahead log' in sql server 2000 ?

1106

Which database stores information about replication?

1126

What is update locks?

935

What is subquery in sql?

1127

Can we delete data from a view?

978