title: Trigger on insert and update that adds modification date
body: <p>I'm making a simple table with names, emails etc, but I also have a <code>ModifiedDate</code>. My idea is to use a trigger after both insert and update, and insert the current date. Thus if anyone does anything (except delete) to that column, the date should reflect that.</p>
  
  <p>This is however not working.</p>
  
  <pre><code>CREATE TRIGGER ModDate
      ON X
      AFTER INSERT, UPDATE
  AS
  BEGIN
  
      INSERT INTO X (ModifiedDate)
      VALUES (GETDATE())
  
  END 
  </code></pre>
  
  <p>Now I have a couple of values that can't be null, and what this seems to do is try and create a new row. I would like it to insert the date into the row that is currently being acted upon, I have no idea how though. Also what if I add 5 rows at once ? </p>