A newly inserted row will be in the 'inserted' table and a newly deleted row will be in the 'deleted' table. See: http://www.sqlteam.com/item.asp?ItemID=3850 for details
From Books Online: deleted and inserted are logical (conceptual) tables. They are structurally similar to the table on which the trigger is defined, that is, the table on which the user action is attempted, and hold the old values or new values of the rows that may be changed by the user action. For example, to retrieve all values in the deleted table, use: SELECT * FROM deleted
1 answers
A newly inserted row will be in the 'inserted' table and a newly deleted row will be in the 'deleted' table.
See: http://www.sqlteam.com/item.asp?ItemID=3850 for details
answered 2 years ago by:
0
From Books Online:
deleted and inserted are logical (conceptual) tables. They are structurally similar to the table on which the trigger is defined, that is, the table on which the user action is attempted, and hold the old values or new values of the rows that may be changed by the user action. For example, to retrieve all values in the deleted table, use:
SELECT *
FROM deleted
answered 2 years ago by:
0
CSF,
Do you guys use SQL Server for your database?
answered 2 years ago by:
0
This post was imported from csharpfriends, if you have a similiar question please ask it again.
All previous members have been migrated, hope you enjoy the new platform!