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:
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|