var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Column List in Update trigger
I want to create an audit trail system in my db but only on certain tables and columns. I know I can do:
what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns.
Does anyone know where this information is held?
ps ASE 11.9.2 on RH Linux
Last edited by wildthing; 10-18-06 at
You can use the trigger generated tables.
The Inserted and Deleted table.
If this is what you mean.
select @col1_before_image=col1 from deleted
select @col1_after_image=col1 from inserted
Not quite - I wanted to get away from the "IF UPDATE" senario and pull in the list of columns that were in the "SET" part of the UPDATE command. Then compare that list to a list of columns I want to track. Thanks anyway.