[AccessD] How does SQL Server do updates

Mark Simms marksimms at verizon.net
Mon Oct 8 19:26:00 CDT 2012


One question: WHY ?

> SQL Server doesn't ever physically update a row, but instead does an
> insert and a delete. This can be verified by creating a trigger For
Update,
> inside which you'll find the tables #inserted and #deleted. In #inserted
> you'll find some of the original row's columns, with new values for the
> columns you changed. Then SQL deletes the row(s) in #deleted, and inserts
the
> "replacement" rows in #inserted.




More information about the AccessD mailing list