title: How to insert value into primary key column in SQL Server?
body: <pre><code>insert into Student 
  values('1', 'joedio', 'newyark', GETDATE())
  </code></pre>
  
  <p>I get this error message when trying to run this SQL:</p>
  
  <blockquote>
    <p>An explicit value for the identity column in table 'Student' can only be specified when a column list is used and IDENTITY_INSERT is ON.</p>
  </blockquote>