for rec in (
select 
id, 
sname 
from t1
)
loop
update t2
set t2.sname = rec.sname
where t2.id = rec.id
end loop

Update t2
Set sname = rec.sname
From t1 rec
join t2 on t2.id = rec.id

UPDATE t2
SET t2.[name]=t1.[name]
FROM t2 JOIN t1 ON t2.id=t1.id
WHERE NOT EXISTS(SELECT t2.[name] INTERSECT SELECT t1.[name]);

use tempdb;
go

create table dbo.t1 (id int identity primary key, f int, v int);
create table dbo.t2 (id int identity primary key, f int, v int);

create index IX_t1__f on dbo.t1 (f);
create index IX_t2__f on dbo.t2 (f);
go

set statistics xml on;

update a
 set
  v = b.v
from
 dbo.t1 a join
 dbo.t2 b on b.id = a.id
where
 exists(select a.f intersect select b.f);

update a
 set
  v = b.v
from
 dbo.t1 a join
 dbo.t2 b on b.id = a.id
where
 not exists(select a.f intersect select b.f);

set statistics xml off;
go
 
drop table dbo.t1, dbo.t2;
go