[AccessD] How does SQL Server do updates

that's been my experience as well...

-Francisco
--------------------------
You should follow me on twitter here <http://twitter.com/seecoolguy>
Blogs: SqlThis! <http://bit.ly/sqlthis>  | XCodeThis!<http://bit.ly/xcodethis>

<http://db.tt/JeXURAx>




On Mon, Oct 8, 2012 at 8:36 AM, Arthur Fuller <fuller.artful at gmail.com>wrote:

> John,
>
> 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.
>
> HTH,
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>