CREATE PROCEDURE PROC10281009 AS BEGIN UPDATE A SET b=B.b FROM table1 A INNER JOIN table2 B ON A.c=B.c INSERT INTO table1 SELECT A.a,A.b,A.c FROM table2 A LEFT JOIN table1 B ON A.c=b.c WHERE B.c IS NULL END 你参考下
MERGE table1 AS target USING table2 as source ON (target.c= source.c) WHEN MATCHED THEN UPDATE SET b= source.b WHEN NOT MATCHED THEN INSERT (a, b,c) VALUES (source.a, source.b,source.c)
AS
BEGIN
UPDATE A
SET b=B.b
FROM table1 A
INNER JOIN table2 B ON A.c=B.c
INSERT INTO table1
SELECT A.a,A.b,A.c
FROM table2 A
LEFT JOIN table1 B ON A.c=b.c
WHERE B.c IS NULL
END
你参考下
USING table2 as source
ON (target.c= source.c)
WHEN MATCHED THEN
UPDATE SET b= source.b
WHEN NOT MATCHED THEN
INSERT (a, b,c)
VALUES (source.a, source.b,source.c)