数据表某列更新为另一个的一列值，怎样实现好

[csdnTimePeriod]

数据表T1(id,name),T2(id,name),需要set t1.name=t2.name where t1.id=t2.id，怎样实现好？

[csdnTimePeriod]

这样写update a set a.name = b.name from T1 a,T2 b where a.id=b.id 执行成功！

[水族杰纶]

update t1 set t1.name=t2.name from t2 where t1.id=t2.id

[LongRui888]

试试这个:

update t1
set t1.name=t2.name 
from T2
where t1.id=t2.id

[Yole]

update a set a.name = b.name from T1 a,T2 b where a.id=b.id