title: How to get next ID upon INSERT?
body: <p>I want to make sure the ID column is incremented for every insert on a table.</p>
  
  <p>I tried this statement:</p>
  
  <pre><code>INSERT INTO Anlagenteil (ID, TaId, Subtype, Name)
  VALUES                  (MAX(ID)+1, 0, 'BdAnlageteil', 'Barcodeleser0');
  </code></pre>
  
  <p>Unfortunately I get this error message:</p>
  
  <pre><code>Msg 207, Level 16, State 1, Line 1
  Invalid column name 'ID'.
  </code></pre>