in principiu au aceeasi structura, singura diferenta = "Audit" are un row in plus (ID) care se auto-incrementeaza cand se adauga date in tabela.

[dupa mai multe incercari]

am incercat sa modific un row deja existent in "TestTable"... si functioneaza codul, copiaza intregul row din tabela "TestTable" in "Audit" - dar daca incerc sa modific inca o data ceva, imi da o eroare "Violation of UNIQUE KEY constraint ....." / "Cannot insert duplicate key in object ......"

problema e, cum modific / incrementez "unique key" ?



CODE:
-
ALTER TRIGGER Trigger1 ON dbo.TestTable FOR UPDATE AS

INSERT INTO dbo.Audit SELECT * FROM deleted
-