title: How to insert into a table with just one IDENTITY column?
body: <p>(Came up with this question in the course of trying to answer <a href="https://stackoverflow.com/questions/850017/how-to-manage-groups-in-the-database/850049#850049">this other one</a>)  </p>
  
  <p>Consider the following MS-SQL table, called GroupTable:</p>
  
  <pre>
  GroupID
  -------
  1  
  2  
  3  
  </pre>
  
  <p>where GroupID is the primary key and is an Identity column.</p>
  
  <p>How do you insert a new row into the table (and hence generate a new ID) <strong>without</strong> using IDENTITY_INSERT ON?</p>
  
  <p>Note that this:  </p>
  
  <pre><code>INSERT INTO GroupTable() Values ()   
  </code></pre>
  
  <p>... won't work.</p>
  
  <p>edit: we're talking SQL 2005 or SQL 2008 here.</p>