Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 30980 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 |
Why I can not enter 0.001 second in date and time literals in ms sql server?
What are ddl triggers and types of ddl trigger?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
In clustered and non clustered indexes which one is faster while executing a query ?
What do you mean by sql server 2005 express management tools?
How to assign new column names in a view?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is the use of DBCC commands?
Do you know what is user defined datatypes and when you should go for them?
What is a data source or ds? : sql server analysis services, ssas
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
How many categories of data types used by sql server?
-
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)
