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-11-12 : 09:21:16
|
| Ian Wilkinson writes "I've been trying to create a trigger that, when a table is updated, will insert into another table (t_Journal) certain information.I'm trying to have one row per value changed.The data being inserted is the name of the table that was updated (nv_Table), the name of the field that was updated (nv_field), the dateTime that the change took place (dt_TimeChange), the value before the update (nv_OldValue) and the new value (nv_NewValue).So far I've been able to get the old and the new values inserted, but I've not been able to find a way of reading the field names.Any Help would be much appreciated.ThanksIan WilkinsonPsGreat Website, I turn here before anywhere else for SQL info." |
|
|
|
|
|
Using Triggers for Journalling