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