Merge Using(데이터 인서트 할 때 테이블에 있는지 비교)

단일 업데이트및 수정

MERGE INTO dbo.TBTable AS A USING ( SELECT @a AS a ,@b AS b ,@c AS c ,@d AS d ) B ON A.a = B.a WHEN MATCHED AND @SaveFlag = 'D' THEN DELETE WHEN MATCHED AND @SaveFlag = 'U' THEN UPDATE SET a = @b , a = @b WHEN NOT MATCHED THEN INSERT (a, c, b, d) VALUES (@a, @c, @b, @d) ;

일괄 업데이트및 수정

MERGE INTO dbo.TABLE T USING( SELECT aa , ss , dd , gg FROM TABLE ) S ON T.gg = S.gg WHEN MATCHED THEN UPDATE SET aa =S.aa , ss = S.ss , dd = S.dd WHEN NOT MATCHED THEN INSERT ( aa , ss , dd , gg ) VALUES( S.aa , S.ss , S.dd , S.gg ) ;