Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-03-05 : 10:49:09
|
| Tony writes "How do I place a autoincrement on a primary key column in a table? How would I write the insert statement for the record?Thanks,Tony" |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2007-03-05 : 11:00:20
|
| use IDENTITY in such cases. it will auto increment the values, numeric only, in a table. event u don't have to mention this field in insert statement. sql server will take care of it.Mahesh |
 |
|
|
|
|
|
autoincrement