Re: Historical data; how?
From: Alan Gutierrez <ajglist_at_izzy.net>
Date: Fri, 17 Jan 2003 17:26:13 GMT
Message-ID: <V0XV9.90904$t06.4324352_at_news2.east.cox.net>
Date: Fri, 17 Jan 2003 17:26:13 GMT
Message-ID: <V0XV9.90904$t06.4324352_at_news2.east.cox.net>
Anton Versteeg wrote:
> Perhaps the following: Create a history table that contains all the columns
> of the table you want keep a history of. Make the columns nullable. Then
> create a trigger that is invoked after an update and that inserts the old
> values into the history table. If a column didn't change then a NULL is
> inserted.
What if the column is changed to NULL?
Alan Gutierrez - ajglist_at_izzy.net Received on Fri Jan 17 2003 - 18:26:13 CET