title: Using a Trigger to GETDATE()
body: <p>I'm using a Trigger to update the Products table to the current date if the value for that column is null. I have everything yet, when I insert the new values into the table the DateAdded column for it says NULL instead of today's current date. I'm not exactly sure what's wrong and why it isn't working. Any help would be appreciated, Thanks!</p>
  
  <pre><code>IF OBJECT_ID('Products_INSERT') IS NOT NULL
  DROP TRIGGER Products_INSERT
  
  CREATE TRIGGER Products_INSERT
  ON Products 
  AFTER INSERT
  AS
  UPDATE Products
  SET DateAdded = GETDATE()
  WHERE DateAdded = NULL;
  </code></pre>