Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Where did the updated record go?

Author  Topic 

cwburke
Starting Member

16 Posts

Posted - 2002-07-26 : 08:24:49
I'm writing an Update trigger on a table and wanted to make sure that I've got this right. When a record has been updated, to view the old data, I would look in the deleted table and to view the new data, I would look in the inserted table. Is that right?

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-26 : 08:26:42
yip

<O>
Go to Top of Page

cwburke
Starting Member

16 Posts

Posted - 2002-07-26 : 08:27:38
Thanks

Go to Top of Page
   

- Advertisement -