title: SqlServer create table with MySql like auto_increment primary key
body: <p>I want to make a table in SqlServer that will add, on insert, a auto incremented primary key.  This should be an autoincremented id similar to MySql auto_increment functionality. (Below)</p>
  
  <pre><code>create table foo  
  (  
  user_id int not null auto_increment,  
  name varchar(50)  
  )  
  </code></pre>
  
  <p>Is there a way of doing this with out creating an insert trigger?</p>