title: Create column to constantly update with rownum in SQL Server
body: <p>I have a table in SQL Server database. It has a column <code>testrownum</code>. I want to update the <code>testrownum</code> column to be rownum whenever row is created in the table automatically. </p>
  
  <p>Is there any setting that I can turn on to achieve this?</p>