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
Explain transaction server explicit transaction?
How to get a list all databases on the sql server?
Why we use trigger in sql server with example?
Can we write trigger for view?
What is report snapshot?
How to create prepared statements using odbc_prepare()?
Is t sql the same as sql server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Some queries related to SQL
Explain left outer join and right outer join?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is the difference between commit and rollback?
How you can find out if an index is useful to the optimizer?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Write an sql query for deleting duplicate rows?