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 |
|
besadmin
Posting Yak Master
116 Posts |
 Posted - 2010-08-19 : 13:02:51
|
| hey friends, just a quick question.i have a table with uid auto generate. say i have 10 records, then insert and delete a few after that. then it will be uid 1-10 and then like 27, 28, and so on.How can i get it so the next rows inserted would start at 11, or the next number in the UID sequence?thanks so much for any help as always! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-19 : 13:31:59
|
| How does it matter you? You can still retrieve records in correct order? You can ensure it gets next sequence correctly, but for that each time you need to have a procedure which checks and rearranges record in case of deletions.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL Restart from last UID