How many types of TRIGGERS are there in MS SQL Server?
Answer Posted / 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 |
Post New Answer View All Answers
What do I need to start working with sql studio? : sql server management studio
What is the difference between grant and with grant while giving permissions to the user?
What is 1nf 2nf?
what are the three command line utilities and what are their primary functions?
Do you know what are the properties of the relational tables?
What is 2nf normalization?
How to transfer a table from one schema to another?
What are the basic features of a trigger in ms sql server?
What are cursors stored procedures and triggers?
Can sql server 2016 run on windows 7?
How to make a remote connection in a database?
Distinguish between commit and rollback?
What is difference between rownum and rowid?
What is awe?
What is the difference between createstatement and preparedstatement?