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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-20 : 09:28:23
|
Luke writes "I'm pretty new to triggers so I'm wondering if this is possible...
When a table is updated I need a trigger to check which fields have been amended and then log which fields have been changed to a history table.
e.g. say a status had been changed from low to high the history table would need to have a new row inserted with the following: 'Status field changed from low to high'.
Using SQL Server 7.0 SP3, WinNT4 SP5." |
|
|
|
|
|
Auto-updating a history of changes table