SQL查询以在表中插入ID

听起来您好像在问如何将这种非规范化的数据分解为三个不同的表。

这就是我要做的。

（我通常不会回答帖子中不包含DDL的问题）

首先，确保所有三个目标表都有identity针对PK定义的字段，以便自动生成键。

填充Surgery。SurgeryID在此表中必须IDENTITY

INSERT INTO Surgery (SurgeryName)
SELECT DISTINCT Surgery FROM YourTable

填充TypeOfSurgery。TypeOfSurgeryId一定是IDENTITY

INSERT INTO TypeOfSurgery (SurgeryID, TypeOfSurgeryName)
SELECT DISTINCT S.SurgeryID, SRC.TypeOfSurgery 
FROM YourTable SRC
INNER JOIN Surgery S
ON S.SurgeryName = SRC.Surgery

填充Procedure。ProcedureId一定是IDENTITY

INSERT INTO Procedure (TypeOfSurgeryId, ProcedureName)
SELECT DISTINCT S.TypeOfSurgeryId, SRC.Procedure
FROM YourTable SRC
INNER JOIN TypeOfSurgery S
ON S.TypeOfSurgeryName = SRC.TypeOfSurgery