java 插入有外键的数据_如何使用外键将值插入现有SQL Server表

我有一个数据库，我想向表中插入新值，问题是我有两个表与FK相互之间 . 我知道问题是 Alter Table 的问题，但我无法弄清楚是什么导致它 .

第一表：部门

CREATE TABLE [dbo].[Department]

(

[DID] [int] primary key,

[Name] [varchar](255) ,

[Description] [varchar](255) ,

[ManagerId] [int]

);

第二张表： OfficialEmployee

CREATE TABLE [dbo].[OfficialEmployee]

(

[EID] [int] primary key,

[StartDate] [date] ,

[Degree] [varchar](255) ,

[DepartmentId] [int] ,

CONSTRAINT [FK_DIDOfficial]

FOREIGN KEY([EID]) REFERENCES [dbo].[Employee] ([EID])

ON UPDATE CASCADE ON DELETE CASCADE,

CONSTRAINT [FK_EIDOfficial]

FOREIGN KEY([DepartmentId]) REFERENCES [dbo].[Department] ([DID])

ON UPDATE CASCADE ON DELETE CASCADE

);

改变表格表达式：

ALTER TABLE [dbo].[Department] WITH CHECK

ADD CONSTRAINT [FK_DepMan]

FOREIGN KEY([ManagerId]) REFERENCES [dbo].[OfficialEmployee] ([EID])

ON DELETE NO ACTION

我只需要有人告诉我如何在其中一个表中插入值

先感谢您