将表2 中 evaluate 字段更新到表1
UPDATE [dbo].[表1]
SET evaluate = c.evaluate
FROM
[dbo].[表2] c ,
[dbo].[表1] i
WHERE
c.id = i.indexId
将表2 中 evaluate 字段更新到表1
UPDATE [dbo].[表1]
SET evaluate = c.evaluate
FROM
[dbo].[表2] c ,
[dbo].[表1] i
WHERE
c.id = i.indexId