title: Automatically update column values in SQL Server
body: <p>I have a table in a SQL Server database with some columns along with </p>
  
  <pre><code>CreatedBy (varchar)
  CreatedOn (datetime)
  UpdatedBy(varchar)
  UpdatedOn(datetime)
  </code></pre>
  
  <p>as standard columns. The <code>CreatedOn</code> and <code>CreatedBy</code> values are automatically populated as and when there is a new row added to this table (using default value approach). </p>
  
  <p>Question: is there any out-of-the-box solution in SQL Server which can pupulate <code>UpdatedOn</code> and <code>UpdatedBy</code> values as and when row updates?</p>