dorin: 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
-
Coloana este identity sau
NEWID ?
Nu merge din cauza ca tu incerci sa inserezi si in coloana respectiva
Incearca cu
ALTER TRIGGER Trigger1 ON dbo.TestTable FOR UPDATE AS
INSERT INTO dbo.Audit(Coloana1,Coloana2, <etc FARA COLOANA DE ID CARE E IN PLUS>) SELECT COLOANA1, COLOANA2 FROM deleted
-
Ignat Andrei
http://serviciipeweb.ro/iafblog