Ceva similar:

T1 (id, id_entitate, versiune_curenta, value1, value2, value3)

T2 (id, id_entitate, versiune, value1, value2, value3)

Pentru update un trigger modifica in T1 versiune_curenta = versiune_curenta + 1, value1, value2, value3 si facea

INSERT INTO T2 (id, id_entitate, versiune, value1, value2, value3)

SELECT id, id_entitate, versiune_curenta, value1, value2, value3

FROM deleted

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro