Create Table on SQL Server

[rodders45]

Does anyone know how to create a primary key field which automatically increments each time you add a new record?

This SQL works in an Access database:

CREATE TABLE News (NewsID AutoIncrement Constraint PrimaryKey PRIMARY KEY, OtherField TEXT (50))

But using SQL Server I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Column or parameter #1:
Cannot find data type AutoIncrement

Can you help?