| 2020/04/17(Fri) 09:41:01 編集(投稿者)
さらに調べてみると以下のようにすればできることがわかりました。
MERGE INTO #TBL AS A USING ( SELECT 5 AS ID, 'SP' AS NAME, 0 AS FLAG UNION SELECT 5, 'SS', 0 UNION SELECT 5, 'S3G', 1 UNION SELECT 5, 'S4G', 0 UNION SELECT 5, 'S5G', 1 ) AS B ON ( A.ID = B.ID AND A.NAME = B.NAME )
WHEN MATCHED THEN UPDATE SET A.FLAG = B.FLAG WHEN NOT MATCHED THEN INSERT (ID, NAME, FLAG) VALUES (B.ID, B.NAME, B.FLAG); |