data types

[quartz]

what is the equivalent data type of autonumber of access in sql server?

[Jonathan Amend]

Just make it a normal int and set Identity = Yes.

"quartz" <pa********@yahoo.com> wrote in message
news:9f**************************@posting.google.c om...

what is the equivalent data type of autonumber of access in sql server?

[Simon Hayes]

pa********@yahoo.com (quartz) wrote in message news:<9f**************************@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