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.