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
Which are the two editions in which SQL Azure database available?
What is bcnf normalization form?
What is the new security features added in sql server 2016? : sql server security
What is global temp table?
How do I clean up sql server transaction log?
Name three of the features managed by the surface area configuration tool? : sql server security
What is enhanced database mirroring in sql server 2008?
What are views in ms sql server?
How important do you consider cursors or while loops for a transactional database?
What is parameterized reports in ssrs ?
How to choose all records from the table?
What should be the fill factor for indexes created on tables? : sql server database administration
What are locks in sql?
What is the difference between upgrade and migration in sql server?
What are the different authentication modes in sql server? How can it be changed?