Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subbarayudu
A Trigger is a block of code,fired whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT,UPDATE,OR DELETE.
whenever trigger fires,two special tables are created-
1.insert table 2.Delete table.
1.inserted table contains copy of all records that are insetred in the trigger table.
2.deleted table contains all records that have been deleted from trigger table.this table is used to refer old values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are sparse columns?
explain different types of cursors? : Sql server database administration
What is mapping schema?
What is molap and its advantage? : sql server analysis services, ssas
Explain sql server authentication modes?
What do you understand by mirroring?
How do I find the sql server database version?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Explain different backup plans?
How to skip remaining statements in a loop block using continue statements?
What are data files?
What is a heap?
What is the use of commit?
What are advantages of ssrs or why we should use ssrs?
Write down the syntax and an example for create, rename and delete index?
