有没有办法将FK从一个到另一个批量插入到两个表中？

CREATE TABLE TableA (
    PK_A INT PRIMARY KEY,
    FK_B INT
);

CREATE TABLE TableB (
    PK_B INT PRIMARY KEY,
    OtherField VARCHAR(50)
);

INSERT INTO TableB (PK_B, OtherField)
VALUES (1, 'Value1'),
       (2, 'Value2'),
       (3, 'Value3');

INSERT INTO TableA (PK_A, FK_B)
SELECT 1, 1
UNION ALL SELECT 2, 2
UNION ALL SELECT 3, 3;