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 - 2002-05-16 : 10:26:17
|
| Partha writes "I have a strange problem. A table has an identity column and 50 records numbered 1 to 50. I delete all the records and re-insert, the numbering starts from 51, not 1 as I expected. Why?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-16 : 10:31:24
|
quote:
the numbering starts from 51, not 1 as I expected
Because your expectations are wrongIf I gave you an ID, say Number 35. Then you left, it would not make any sense if I gave ID Number 35 to someone else. Because then how could I tell the difference between what you had done, and what someone else had done.Damian |
 |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-16 : 10:33:21
|
| if you want it to restart from 1 check for DBCC CHECKIDENT in BOL.-------------------------------------------------------------- |
|
|
|
|
|
|
Identity problem