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 |
|
moramoga
Starting Member
34 Posts |
 Posted - 2006-12-06 : 19:29:48
|
| Let me clarify this a bit better... there is a table that I need to use as a 'log book' of sorts, which records every insert, update, and delete by use of triggers. This is simple enough however for the Update functions, I need the trigger to write in one column the 'old value' and the 'new value' that was changed.Thanks in advance |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-06 : 19:35:45
|
| Have you had a look at Books Online on triggers?You should be able to fathom what you need to do based on that. If you have more questions after reading BOL, don't hesitate to post them. |
 |
|
|
moramoga
Starting Member
34 Posts |
Posted - 2006-12-06 : 20:36:30
|
| Still need the help.... |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-12-06 : 21:07:40
|
| So Books Online didn't help at all? I find that hard to believe.You're more likely to find help here if you at least attempt to do it yourself and post your code if it's not working. |
|
|
|
|
|
|
trigger...