SQL Server auto-increment primary key
create table TABLE1
(id int not null auto_increment primary key
);
but it did not work. Please help
[238 byte] By [galgal5814] at [2007-11-11 8:15:33] 
Can someone teach me how to auto increment the primary key? I am currenlty using ms sql server 2000. I had tried
create table TABLE1
(id int not null auto_increment primary key
);
but it did not work. Please help
# 1 Re: SQL Server auto-increment primary key
The property you want is IDENTITY: http://msdn.microsoft.com/library/en-us/tsqlref/ts_ia-iz_3iex.aspPhil Weber at 2007-11-11 23:47:09 >
# 2 Re: SQL Server auto-increment primary key
Thank you.:)galgal5814 at 2007-11-11 23:48:09 >
