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 - 2005-03-15 : 07:52:59
|
| Deep writes "Dear Sir, I am a very lowsy fellow and stuck in a problem that I have a table in which I have a primary key field and I have made it identity field. I have 100 rows i.e. with identity field value from 1-99. By mistake I deleted row with identity field with id 95. Now I am inserting new row n the identity is coming as 100 as usual. How can I insert a row with identity value 95.Plz advice.Thanks a lot in advance.Deep Sharma. (India)" |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-15 : 08:12:19
|
| You will need to use the commandSET IDENTITY_INSERT ON-------Moo. :) |
 |
|
|
Hippi
Yak Posting Veteran
63 Posts |
Posted - 2005-03-15 : 20:22:33
|
quote:
Originally posted by mr_mist
You will need to use the commandSET IDENTITY_INSERT ON-------Moo. :)
And don't forget to set it off after inserting the row you want. |
|
|
|
|
|
|
Identity Field.