title: Adding new column and set GETDATE as value in SQL Server 2017
body: <p>This is my query:</p>
  <pre><code>alter table reseau add datemodification datetime default getdate()
  </code></pre>
  <p>After execution the rows have <code>NULL</code> as their value but I want them set to the current value of <code>GETDATE()</code>.</p>
  <p>How can do I do this?</p>