Carl Farmer
SSCrazy
Points: 2197
More actions
February 10, 2003 at 3:05 am
#159461
In my create table statement, I would like the value of one field to be an ID that increments by one every time there is an update, can someone please remind me of the SQL for this, thanks.
Antares686
SSC Guru
Points: 125444
February 10, 2003 at 3:58 am
#448494
colname inttype IDENTITY(1,1) NOT NULL
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply