title: How do I add a “last modified” and "created" column in a SQL Server table?
body: <p>I'm design a new db schema for a SQL Server 2012 database.</p>
  
  <p>Each table should get two extra columns called <code>modified</code> and <code>created</code> which should be automatically change as soon a row gets inserted or updated.</p>
  
  <p>I don't know how rather the best way to get there.</p>
  
  <p>I assuming that trigger are the best way to handle it.</p>
  
  <p>I was trying to find examples with triggers.. but the tutorials which I found insert data in another table etc. </p>
  
  <p>I assumed it's a quite common scenario but I couldn't find the answer yet.</p>