Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of TRIGGERS are there in MS SQL Server?
- 8 Answers
- 31347 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 variables called the most powerful component of ssis?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Explain about merge replications?
What is difference between views and tables?
what is normalization? what is denormalization?
When we can say that is in BCNF?
Explain concepts of analysis services?
what are the types of indexes? : Sql server database administration
What are the new security features added in sql server 2012? : sql server security
What do you mean by the term 'normalization'?
What is data file in computer?
What are different types of statement?
-
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)
