Rank: Newbie
Groups: Member
Joined: 3/15/2007
Posts: 1
Points: 0
|
Hey, How would i go about creating a auto increment for a coloumn. Basically creating a unique key hat would increment that i could use. Any help would be appreciated 
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Hi
When creating the column, choose the properties like below:
Data Type: int
Allow nulls: false
Is Identity: true
Identity Increment: 1
Identity Seed: 1
If you want to use this column as a primary key, then you can check the Key checkbox.
Hope this helps
|