如何在SQL Server中插入以parentCode填充的表

CREATE TABLE ParentTable (
    parentCode INT PRIMARY KEY,
    parentName NVARCHAR(100)
);

CREATE TABLE ChildTable (
    childCode INT PRIMARY KEY,
    childName NVARCHAR(100),
    parentCode INT,
    FOREIGN KEY (parentCode) REFERENCES ParentTable(parentCode)
);

-- 插入父表数据
INSERT INTO ParentTable (parentCode, parentName) VALUES (1, 'Parent One');

-- 插入子表数据，并引用父表的parentCode
INSERT INTO ChildTable (childCode, childName, parentCode) VALUES (101, 'Child One', 1);

-- 确保父表已有数据
IF NOT EXISTS (SELECT 1 FROM ParentTable WHERE parentCode = 1)
BEGIN
    INSERT INTO ParentTable (parentCode, parentName) VALUES (1, 'Parent One');
END

-- 插入子表数据
INSERT INTO ChildTable (childCode, childName, parentCode) VALUES (101, 'Child One', 1);