Creating table with autonum field

[michelleqw]

Dear sql kids,

We am trying to create a table with an autonumbering field, knows someone the syntax?

Good start of 2005!

Michelle.

 

[michelleqw]

We did found the answere:

tlbroadbent (MIS) May 21, 2002

Use Identity to create a an auto incrementing column.

Create table MyTable
(RecID Int Identity, PartNo varchar(16), ...)

You can specift an identity seed and increment value, also.

Create table MyTable
(RecID Int Identity(101,1), PartNo varchar(16), ...)

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

FAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.