title: What happens if you override an auto-increment primary key value in SQL Server?
body: <p>Say I have a table with an auto-incremented primary key. In Oracle, the auto-increment is done through a sequence, and in SQL Server, this is pre-defined in the table creation using the <code>IDENTITY</code> keyword.</p>
  
  <p>I manually insert a record into this table and include the primary key value. This causes problems in Oracle because the sequence is still referencing the last value prior to this insert.</p>
  
  <p>What would the behavior be in SQL Server?</p>