>CREATE TRIGGER [ReceptionDetail$UPDATE] ON [dbo].[IN_ReceptionDetail] >FOR UPDATE >AS > > >IF UPDATE(nQuantiteRecu) > BEGIN > UPDATE IN_ItemEntrepot SET nEnMainQuantite = nEnMainQuantite - DELETED.nQuantiteRecu + INSERTED.nQuantiteRecu FROM IN_ItemEntrepot > JOIN INSERTED ON INSERTED.fk_Item = IN_ItemEntrepot.fk_Item AND INSERTED.fk_Entrepot = IN_ItemEntrepot.fk_Entrepot > JOIN DELETED ON DELETED.ID = INSERTED.ID > END > >>