[MS-SQL] MERGE(Transact-SQL)

https://learn.microsoft.com/ko-kr/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver16 

MERGE(Transact-SQL) - SQL Server

 

• 단일 테이블 적용 예제

MERGE INTO [dbo].[Game]  -- 적용 테이블 
USING (SELECT 1 AS DUAL) AS tmpDual  -- Dummy SubQuery
ON (AccountID = @AID)     -- 비교문 (WHERE)
WHEN MATCHED THEN         -- 매칭
    UPDATE SET Level = @Level
WHEN NOT MATHCED THEN    -- 매칭 안됨
    INSERT (AccountID, Level) VALUES (@AID, @Level);