Posted by Ed Murphy on 12/15/06 02:49

Erland Sommarskog wrote:

> Matik (marzec@sauron.xo.pl) writes:

>> and by programming, I need always to shift this properities into
>> history table, whith indexes to a history table of other properities.
>
> Don't really know what you mean here.

Probably something along the lines of: (oversimplified for brevity)

insert into FooHistory select * from CurrentFoo
delete from CurrentFoo

[Back to original message]