Where is AutoNumber DataType in SQLServer 2005

[lcky]

Hi

I have just download SQL Server Express 2005. I have created a test table to see what it look like.

In previous version of SQL Server, there was a dataType 'AutoNumber'. Which allow to assign sequence number. It was very handy for a primary key.
But I could find AutoNumber Datatype in this version.

Please could you help me, how I do get same function in SQL Server 2005.

many thank

 

[SQLDenis]

It's called an identity field

here is an example

create table testid (id int identity, DateValue datetime)

insert into testid
select getdate()

select * from testid


you can run this in a query window

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

You're looking for the identity property.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3iex.asp

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLBill]

There never was an Autonumber in SQL Server 2000. As everyone else stated, you must mean IDENTITY.

-SQLBill

Posting advice: FAQ481-4875