data types

what is the equivalent data type of autonumber of access in sql server?Just make it a normal int and set Identity = Yes.

"quartz" <paeng01_66@.yahoo.com> wrote in message
news:9fb191e4.0405231843.6bebf0a9@.posting.google.c om...
> what is the equivalent data type of autonumber of access in sql server?|||paeng01_66@.yahoo.com (quartz) wrote in message news:<9fb191e4.0405231843.6bebf0a9@.posting.google.com>...
> what is the equivalent data type of autonumber of access in sql server?

You can use the IDENTITY property:

create table dbo.Test (
idcol int identity(1,1) not null primary key
)
go

See Books Online for more details.

Simon