Re: Adding an auto-increment column to existing table with a particular order
Posted by Yannick Turgeon on 10/24/05 19:41
Thanks all for you time on this question.
I clearly understand that IDENTITY shouldn't mean anything and it is
not that important that it follows exactly my "sort wishes". It was
simply to make table hacking more consistant with other tables where I
sort by IDENTITY to see last insertions. Using the INSERT INTO...
SELECT... ORDER BY will do the job... I hope so! ;o)