title: SQL Server - What happens when a row in a table is updated?
body: <p>I seem to recall that when a row in a table is updated, SQL Server first deletes the row, and then re-adds the row, with the same Identity value for a column, if such a column exists. Can anyone confirm this?</p>