title: SQL Server: Cannot insert an explicit value into a timestamp column
body: <p>When using this statement</p>
  
  <pre><code>create table demo (
      ts timestamp
  )
  
  insert into demo select current_timestamp
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column</p>
  </blockquote>
  
  <p>How do I insert the current time to a <code>timestamp</code> column?</p>