主表1 students 设计:
column name data type allow nulls
sname nchar(10) n
P_K<-----scode identity(int ,1,1) n
saddress nchar(50) y
sgrade nchar(10) y
semail nchar(10) n
子表 score 设计:
column name data type allow nulls
F_K1<----studentid indentity(int,1,1) n
F_K2<----courseid nchar(20) n
score float y
scoreid nchar(10) n
主表2 course 设计:
column name data type allow nulls
P_K<---courseid nchar(20) n
coursename nchar(40) n1问题来了:我在对score 进行插入数据时候,显示外键冲突/主键约束,没办法插入数据呀!!
2score 内部的只有一个CHK_CONSTRAINT ,0<SCORE AND SCORE<1003代码
USE ACCP
GO
INSERT INTO score(score,scoreid,courseid)
SELECT 82,'B','JAVA' UNION
SELECT 65,'D','HTML' UNION
SELECT 70,'C','JAVA' UNION
SELECT 40,'C','SQL' UNION
SELECT 60,'D','C#' UNION
SELECT 70,'C','JAVA' UNION
SELECT 60,'D','HTML' UNION
SELECT 66,'D','JAVA' UNION
SELECT 85,'B','HTML' union
SELECT 64,'D','JAVA' 4 报错:
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_Score'. Cannot insert duplicate key in object 'dbo.score'.
这个问题困扰了我很久,请老师指导一下!!
column name data type allow nulls
sname nchar(10) n
P_K<-----scode identity(int ,1,1) n
saddress nchar(50) y
sgrade nchar(10) y
semail nchar(10) n
子表 score 设计:
column name data type allow nulls
F_K1<----studentid indentity(int,1,1) n
F_K2<----courseid nchar(20) n
score float y
scoreid nchar(10) n
主表2 course 设计:
column name data type allow nulls
P_K<---courseid nchar(20) n
coursename nchar(40) n1问题来了:我在对score 进行插入数据时候,显示外键冲突/主键约束,没办法插入数据呀!!
2score 内部的只有一个CHK_CONSTRAINT ,0<SCORE AND SCORE<1003代码
USE ACCP
GO
INSERT INTO score(score,scoreid,courseid)
SELECT 82,'B','JAVA' UNION
SELECT 65,'D','HTML' UNION
SELECT 70,'C','JAVA' UNION
SELECT 40,'C','SQL' UNION
SELECT 60,'D','C#' UNION
SELECT 70,'C','JAVA' UNION
SELECT 60,'D','HTML' UNION
SELECT 66,'D','JAVA' UNION
SELECT 85,'B','HTML' union
SELECT 64,'D','JAVA' 4 报错:
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_Score'. Cannot insert duplicate key in object 'dbo.score'.
这个问题困扰了我很久,请老师指导一下!!
表 A (id int,b int)表 B (fid int,b int) 假设fid是外键,关联表A.id,那么向表B插入(5,3)的时候,要先确保表A内有5