SqlServer create table with MySql like auto_increment primary key

Question

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)

create table foo  
(  
user_id int not null auto_increment,  
name varchar(50)  
)  

Is there a way of doing this with out creating an insert trigger?

Answer 1

Like this

create table foo  
(  
user_id int not null identity,  
name varchar(50)  
)