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