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-07-16 : 09:43:34
|
| Salem writes "I have created a table which has Identity column generates id increment by 1.I am also deleting the records from this table ,so id is not sequential I mean for e.g If id -- 1 2 3 4 ....then when i delete 3rd record then it is 1 2 4 .I want to serialize this as 1 2 3 .Please advise what to should be done in this case to serialize the data wheneve any delete opearation is done on the table" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-07-16 : 09:43:34
|
| We just published an article on finding holes in a sequence number. You can use this article (http://www.sqlteam.com/item.asp?ItemID=765) to generate sequence number. |
 |
|
|
|
|
|
To Serialize Identity Column