Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autonumber Column

Status
Not open for further replies.
tbpowers

tbpowers

MIS
Sep 10, 2008
16
0
0
US
I set up a new column and would like it to autonumber records. How do I go about this? Here is what I have setup.

NMR_No (PK, varchar(30), not null)
 
Sort by date Sort by votes
you need to specify the column as an identity column.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
141
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
166
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Update another column if text in another exists 2
Replies
4
Views
59
Cpreston
Cpreston
EM1107
  • Locked
  • Question
Converting data from rows to column.
Replies
12
Views
82
EM1107
EM1107
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
76
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top