Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 31623 Views
- CarrizalSoft Technologies, TCS, United Healthcare, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 68 Yes | 13 No |
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
| Is This Answer Correct ? | 33 Yes | 8 No |
Answer / yugal
SQL Server 2008 includes three general types of triggers:
1)DML triggers
2)DDL triggers
3)Logon triggers.
| Is This Answer Correct ? | 26 Yes | 5 No |
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)
| Is This Answer Correct ? | 13 Yes | 4 No |
Answer / balaji
which one is correct?
ISthis DML,DDL,CLR or Instead of trigger, after trigger
| Is This Answer Correct ? | 15 Yes | 9 No |
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
| Is This Answer Correct ? | 10 Yes | 4 No |
What is the difference between index seek vs. Index scan?
What’s the distinction between dropping a info and taking a info offline?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are the source of constraints?
Why SQL Agent is used?
What is dirty page?
What does <> symbol mean?
What is a system database and what is a user database?
What is a scheduled job or what is a scheduled task?
How to get @@error and @@rowcount at the same time?
Which one is faster delete/truncate? Why?
What are the restrictions while creating batches in sql server?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
