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 |
|
rupalim
Starting Member
20 Posts |
 Posted - 2010-08-14 : 00:52:40
|
| how to resolve the problem using identity ?? suppose m using identity in my table and if i delete one of the record then it inserts values from the next record so,how to resume the records.ex: if i delete the 3 record and again i want to insert values from 3rd record so ,how should i tackle such problem ??could anyone provide me any solution for this??? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 00:59:56
|
| you need to use settingSET IDENTITY_INSERT ON and insert value explicitly as 3but question is why should you worry on this?you can still retrieve records in correct order in spite of gaps------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-14 : 01:20:41
|
| At the first time that every one feel the same question after onwards they will knew starting the same question raised to me also and now its notWith RegardsKashyap M |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 01:24:42
|
quote:
Originally posted by kashyap_sql
At the first time that every one feel the same question after onwards they will knew starting the same question raised to me also and now its notWith RegardsKashyap M
sorry didnt get your point------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-08-14 : 01:30:24
|
| i mean when we started over career on sql first we do insert, delete and update when we delete some data in a table contain identity column we just want blindly the sequence of the columns then comes the question got my point i had the same question when i started my career :)With RegardsKashyap M |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-14 : 01:58:04
|
oh ok...  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Issues