title: Does my trigger updates all the records
body: <p>I have written a simple trigger which sets a column value with the id column value.
  This is my trigger.</p>
  
  <pre><code>CREATE TRIGGER SubSectionsPrioritytrigger
  ON SubSections
  AFTER INSERT
  AS
  UPDATE dbo.SubSections
  SET Priority = Id
  </code></pre>
  
  <p>After writing this trigger that, does this updates all the records after each insert. Or the only created new row.</p>
  
  <p>Could some one provide any info on this.</p>
  
  <p>Thanks.</p>