[AccessD] How does SQL Server do updates

Arthur Fuller fuller.artful at gmail.com
Tue Oct 9 16:05:26 CDT 2012


Precisely my point, Jim. In-situ updates by definition destroy data and
prevent rollbacks; hence the delete-then-insert scenario, without which a
rollback would be impossible. Thus, UPDATE is a glorified term for DELETE
then INSERT. No other way to make it all work. Nuff said,,, or perhaps for
the sake of performance you would prefer to sacrifice RollBack.

A.


More information about the AccessD mailing list