Intrebarea mea este , daca intr-un mediu de retea , web userii acceseaza concomitent acest tabel si realizeaza diferite operatii tabele acestea "Inserted si Deleted" imi mai pot oferii operatia corecta corespunzatoare unui user unei comenzi [SQL INSERT/UPDATE/DELETE] ? > DA ! Pseudotabelele INSERTED si DELETED memoreaza doar înregistrările (liniile) cu valorile noi (INSERTED -> adaugare şi modificare) şi vechi (DELETED -> modificare şi ştergere) afectate de comanda SQL I/U/D curentă.

http://msdn.microsoft.com/en-us/library/ms191300.aspx

The deleted table stores copies of the affected rows during DELETE and UPDATE statements. During the execution of a DELETE or UPDATE statement, rows are deleted from the trigger table and transferred to the deleted table. The deleted table and the trigger table ordinarily have no rows in common.

The inserted table stores copies of the affected rows during INSERT and UPDATE statements. During an insert or update transaction, new rows are added to both the inserted table and the trigger table. The rows in the inserted table are copies of the new rows in the trigger table.