Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 30985 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 a collation in ms sql server?
What are the 10 characteristics of data quality?
Explain triggers?
How network traffic be reduced by using the stored procedure?
what is the different types of backups available in sql server? : Sql server database administration
Describe and explain about SQL native client?
how to delete duplicate rows in sql server2005
7 Answers Cisco, CTS, HCL, IBM,
How to connect php with different port numbers?
Explain the types of indexes.
How do you optimize Sql queries ?
What is Sqlpaging in SqlServer 2005 ?
syntax for deleting the database in T SQL
-
Oracle (3259) - 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)
