SqlServer数据库-根据查询出的值来修改另一个表的值
根据查询出的值来修改其他表的值。
UPDATE a set a.ProcessStatus = 'C', a.ProcessTime = getdate(), a.ExecDate = b.ExecDate
FROM transport AS a ,vi_Surgery AS b
WHERE a.IdHospSurgery = b.IdHospSurgery AND b.ExecDate IS NOT NULL
AND b.ExecDate <> '1900-01-01 00:00:00.00
原创
2020-09-30 17:07:49 ·
2141 阅读 ·
6 评论