incearca  :

begin transaction trx
--verificare
select top 100 id,  numar from facturi order by id

update Facturi  set numar = fb.numar
from Facturi inner join Facturi_backup fb on Facturi.id=fb.id

--verificare
select top 100 id,  numar from facturi order by id

rollback transaction  trx

---

Ignat Andrei
http://serviciipeweb.ro/iafblog