Triggers use two logical tables called the INSERTED and the DELETED table. These tables are accessed only inside triggers and you cannot directly modify the data in the tables. The tables hold the new and old rows of the data being inserted or deleted.
If you DELETE a row , a row will be created in the DELETED table. Similarly if you INSERT a row, a row is created in the INSERTED table. If you update a record with an UPDATE statement, the INSERTED table will contain the updated row and a previous state of the row will be added to the DELETED table.
Note: You cannot use a CREATE INDEX on these tables.
Read more about INSERTED and DELETED tables over here:
http://msdn2.microsoft.com/en-us/library/ms191300.aspx
nice tut.... but it will be more useful if given with an example.....
ReplyDelete