SQL Server 2017

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

CREATE TABLE A
(
    ID1 INT,
    ID2 INT,
    ID3 INT,
    FOO INT, 
    BAR INT,
    PRIMARY KEY (ID1, ID2, ID3)
);

CREATE TABLE B
(
    ID1 INT,
    ID2 INT,
    ID3 INT,
    FOO INT, 
    BAR INT,
    PRIMARY KEY (ID1, ID2, ID3)
);
CREATE TRIGGER TRG_A_INSDEL
ON [A]
AFTER INSERT, DELETE
AS
BEGIN

    INSERT INTO B
        SELECT * FROM inserted;
    
    DELETE B
    FROM
        B
    JOIN
        deleted d
        ON d.ID1 = B.ID1
        AND d.ID2 = B.ID2
        AND d.ID2 = B.ID2;
END
INSERT INTO A VALUES (1, 1, 1, 1, 1);
INSERT INTO A VALUES (2, 2, 2, 2, 2);
INSERT INTO A VALUES (3, 3, 3, 3, 3);
6 rows affected

SELECT * FROM B;


ID1
ID2
ID3
FOO
BAR


1
1
1
1
1

2
2
2
2
2

3
3
3
3
3


DELETE FROM A WHERE ID1 >= 2;
4 rows affected

SELECT * FROM B;


ID1
ID2
ID3
FOO
BAR


1
1
1
1
1