update b set b.FieldName=1 from TableName1 a
inner join TableName2 b
on a.id = b.dhid
where a.lx=2
SQL server两表关联更新
最新推荐文章于 2024-08-26 03:15:11 发布
update b set b.FieldName=1 from TableName1 a
inner join TableName2 b
on a.id = b.dhid
where a.lx=2