title: SQL Server Identity Column Insert Fails
body: <p>Hi guys I just have one quick question: </p>
  
  <p>what happens when an insert statement fails on an identity column?</p>
  
  <p>Is it possible that say for example that if I insert a row with an identity column, that identity column will be 1, and insert again but that fails and does not insert and data. Then try to insert again and that identity for that row is now 3?</p>
  
  <p>Any advice will be much appreciated.</p>
  
  <p>Thanks.</p>