title: use current date as default value for a column
body: <p>Is there a way to set the default value of a column to <code>DateTime.Now</code> in Sql Server?</p>
  
  <p>Example:</p>
  
  <pre><code>table Event
  Id int (auto-increment) not null
  Description nvarchar(50) not null
  Date datetime not null
  </code></pre>
  
  <p>The line:</p>
  
  <pre><code>Insert into Event(Description) values('teste');
  </code></pre>
  
  <p>should insert a row and the Date value should be the current date.</p>