--第一种办法 UPDATE B SET B.COL2=A.COL2,B.COL3=A.COL3,..... FROM B INNER JOIN A ON B.ID=A.ID INSERT INTO B SELECT * FROM A WHERE NOT EXISTS( SELECT 1 FROM B WHERE B.ID=A.ID )--第二种办法 DELETE FROM B WHERE ID IN (SELECT ID FROM A) INSERT INTO B SELECT * FROM A
--第一种办法
UPDATE B SET B.COL2=A.COL2,B.COL3=A.COL3,.....
FROM B
INNER JOIN A ON B.ID=A.ID
INSERT INTO B
SELECT * FROM A WHERE NOT EXISTS(
SELECT 1 FROM B WHERE B.ID=A.ID
)--第二种办法
DELETE FROM B WHERE ID IN (SELECT ID FROM A)
INSERT INTO B SELECT * FROM A