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 |
|
s2002
Starting Member
49 Posts |
 Posted - 2009-04-08 : 04:28:32
|
| hi,I use .net webApplication to insert data to DB. There is an ID field on the table which is autonumber . AutoNumber Field doe not provide sequential numbers in some cases , Suppose 7560 , 7580 .Could I recover non-Existance Numbers for ID field, Suppose 7561,7562,....sincerley,Smith |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-08 : 05:04:33
|
| Why does gap matter in identity column?MadhivananFailing to plan is Planning to fail |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-08 : 05:06:28
|
Unless the maximum value have been reached as describeb in the blog post above...
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
AutoNumber field Issue