SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

REPLACE INTO tablename (keycol, col1, col2)
VALUES ('A','B','C'),
       ('C','D','E'),
       ('F','G','H'),
       ('I','J','K');
Msg 156 Level 15 State 1 Line 1
Incorrect syntax near the keyword 'INTO'.

CREATE TABLE tablename(keycol CHAR(1) PRIMARY KEY, col1 CHAR(1), col2 CHAR(1))
INSERT INTO tablename(keycol, col1, col2) VALUES('A', 'X', 'X'); -- to be updated
1 rows affected

SELECT * FROM tablename;


keycol
col1
col2


A
X
X


MERGE tablename trg
USING (VALUES ('A','B','C'),
              ('C','D','E'),
              ('F','G','H'),
              ('I','J','K')) src(keycol, col1, col2)
  ON trg.keycol = src.keycol
WHEN MATCHED THEN
   UPDATE SET col1 = src.col1, col2 = src.col2
WHEN NOT MATCHED THEN
   INSERT(keycol, col1, col2)
   VALUES(src.keycol, src.col1, src.col2);
4 rows affected

SELECT * FROM tablename;


keycol
col1
col2


A
B
C

C
D
E

F
G
H

I
J
K