hi guys i was wondering if anyone could help me, i have a table with a field called id that did have numbers 1,2,3,4,5,6,7,8 and so on! but after some tinkering i have removed a few value and added more so i now have 1, 4,8,19,20 and so on!
i was wondering if i can run a query to update those value and return them to 1,2,3,4,5,6,7,8 and so on?
Cheers
Tupps
This article might help
http://www.juliankuiters.id.au/article.php/sql2000-reset-identity
|||sorted thanks!! couldnt get an answer! but thats cos i wasnt using the correct term cheers!!
Tupps
No comments:
Post a Comment