May 25, 2002 at 4:03 am
How do we retrieve the contents of a row modified when a corresponding col is changed
in an update trigger
May 25, 2002 at 5:04 am
Hi Sreevani
If you are modifing a record, first Sql server delets the record and then insert a new record with the modified value. Here the deleted table contains the old values and inserted table contains the new values. Further information like how to use and all you can get from SQL Server help.
May 25, 2002 at 11:56 am
Inside the trigger, you can select * from inserted to see the new values, select * from deleted to see the old. You can compare these, join the tables, even join with the modified table to manipulate the data.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy