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.
| Author |
Topic |
|
ronstone
Starting Member
32 Posts |
 Posted - 2004-03-08 : 15:13:00
|
| I have a table with a bunch of rows.I want to update this table, and then somehow show only the rows that changed (before and after values) for auditing purposes.Should I copy the original table into a temp table, make updates, then do a left join the table on the temp table on each column to see if they match?Or is there built in functionality to handle this?Thanks! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-03-08 : 15:35:47
|
| Create an Update_DT column.Also create a history table that looks like and create a trigger to move the updated rows...Then union the tables together...Brett8-) |
 |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2004-03-09 : 03:27:42
|
| To add to Brett you might want to look at BOL for 'Using the inserted and deleted Tables'.--Frankhttp://www.insidesql.de |
|
|
|
|
|
|
Showing row changes for auditing purposes