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 - 2001-03-28 : 17:33:29
|
sudha writes "IF we set the identity for a column, say identity seed is 1 and increment is 1...
now if i insert say three rows they will have 1,2,3 as the values..right! now if i delete 1 row and again insert another the value will be 4 which i don't want ..i want it to be reset at 3..
i mean it should reset automatically..how would you do that..please help..
please email me the answer if possible. the version of sql server is 6.5
Thanks and Regards
sudha" |
|
|
|
|
|
query about setting identity column