SQL Server 中如何用一个表的数据更新另一个表中的数据
for ACCESS 数据库:
update a, b set a.name=b.name1 where a.id=b.id
for SQL Server 数据库:
"update a set a.name=b.name1 from a,b where a.id=b.id"
以下在SQL Server中验证可行：
update a set a.status=b.status
from table1 a,table2 b
where a.id1=b.id1
update a inner join b on a.a1=b.b1 set a.a2=b.b2条件
update table1 set a.status = b.status
from table1 a inner join table2 b
on a.idl = b.idl
http://topic.iyunv.com/t/20041013/14/3451961.html
http://www.iyunv.com/hanguoji/archive/2007/02/01/636723.aspx
页:
[1]