"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
