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
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
转载于:https://www.cnblogs.com/xuelixue/p/8543866.html