title: SQL Server trigger and INSERTED and DELETED table records
body: <p>When running a batch UPDATE statement (ie. a statement that updates multiple records at once), do the Inserted and Deleted tables contain the same number of records and are the records in the same order (ie. record at pos 0 of Inserted corresponds to record at pos 0 of Deleted)?</p>
  
  <p>Also...</p>
  
  <p>I have an update statement...</p>
  
  <pre><code>UPDATE table SET column = value WHERE id = idvalue
  </code></pre>
  
  <p>If originally, the column had a value of 1, and the update sets the column's value = 1 also, both the inserted and deleted tables have one record and the column is flagged as changed (even though it didn't). Is this normal behavior?</p>