title: Automatically add and persist the current date in the database
body: <p>I want to create a database which has one date column that needs to be automatically filled with the current date. 
  I tried the following design in Sql Management Studio:
  <img src="https://i.stack.imgur.com/LKEU3.jpg" alt="enter image description here"></p>
  
  <p>The problem with this desing is that every time I insert a new record to the table, all DateEffective rows change to the current date, and I need only the last row to change.
  Is there any solution to this problem?</p>
  
  <p>Thanks!</p>