Answer Posted / jerry joseph
Trigger gets executed when an INSERT UPDATE or DELETE occurs
2 types of triggers are INSTEAD OF triggers and AFTER triggers
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What are the new features of sql server 2012 reporting service?
What is candidate key with example?
What are four major operators that can be used to combine conditions on a where clause?
List the data types available in mssql?
What is single-user mode?
Which data type columns are the best candidates for full-text indexing?
What is difference between createstatement and preparedstatement?
What is sql server replication? : sql server replication
Define master database?
What is sql server profiler trace data file?
What happens if null values are involved in comparison operations?
Explain identity in sql server?
Why the trigger fires multiple times in single login?