批量更新sql
UPDATE TABLE_1 SET COL_1=TT2.RESULT_COL_1,COL_2=TT2.RESULT_COL_2 FROM TABLE1 AS TT1 INNER JOIN (SELECT RESULT_COL_1,RESULT_COL_2 FROM TABLE_2) AS TT2 ON TT2.RELATION_COL=TT1.RELATION_COL
posted @ 2018-07-17 14:46 huangfenggu 阅读(100) 评论(0) 推荐(0) 编辑