[MSSQL] Multi UPDATE, 다중 UPDATE

출처 : blog.naver.com/PostView.nhn?blogId=windlee5&logNo=20188054172

MSSQL 다중 UPDATE 문장. MSSQL MULTI UPDATE

--1. 일반적인 방법
UPDATE [TABLE_1]
   SET COL1 = SUB_COL1
     , COL2 = SUB_COL2
     , COL3 = SUB_COL3
 FROM
 (
     SELECT SUB_COL1
	      , SUB_COL2
		  , SUB_COL3
		  , USER_NUM
       FROM [TABLE_2]
      WHERE [조건...]
 ) SUB1
WHERE [TABLE_1].USER_NUM = SUB1.USER_NUM

--2. CTE 를 사용한 방법
WITH CTE_TABLE AS
(
    SELECT SUB_COL1, SUB_COL2, SUB_COL3, USER_NUM
      FROM [TABLE_2]
     WHERE [조건...]
)
UPDATE [TABLE_1]
   SET COL1 = SUB_COL1
     , COL2 = SUB_COL2
     , COL3 = SUB_COL3
  FROM CTE_TABLE SUB1
 WHERE [TABLE_1].USER_NUM = SUB1.USER_NUM