numbering records | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

numbering records

I have a 50,000 records table and now i need put a new field (id_x). Do you know how i fill ‘id_x’ field with 1,2,3,4,5,…. 50000? Thanks,
Antonio Arciga

Duplicate post. The other one is in Spanish Forum.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
]]>