Hỏi đáp
Chia sẻ kiến thức, cùng nhau phát triển
Anh Long cho em hỏi: Sao bảng kết quà em nhập liệu đúng như thế này: https://drive.google.com/file/d/1eaWu6IFsiknNQRyM8IQWBevHu9dMPS8j/view rồi mà sao nó vẫn báo lỗi:
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212001', -- MASINHVIEN - varchar(40)
'THT01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
4 -- DIEM - float
)
--2
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212001', -- MASINHVIEN - varchar(40)
'THT01', -- MAMONHOC - varchar(40)
2, -- LANTHI - int
7 -- DIEM - float
)
--3
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212002', -- MASINHVIEN - varchar(40)
'THT01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
8 -- DIEM - float
)
--4
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212003', -- MASINHVIEN - varchar(40)
'THT01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
6 -- DIEM - float
)
--5
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212004', -- MASINHVIEN - varchar(40)
'THT01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
9 -- DIEM - float
)
--6
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212001', -- MASINHVIEN - varchar(40)
'THT02', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
8 -- DIEM - float
)
--7
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212002', -- MASINHVIEN - varchar(40)
'THT02', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
5.5 -- DIEM - float
)
--8
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212003', -- MASINHVIEN - varchar(40)
'THT02', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
4 -- DIEM - float
)
--9
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212003', -- MASINHVIEN - varchar(40)
'THT02', -- MAMONHOC - varchar(40)
2, -- LANTHI - int
6 -- DIEM - float
)
--10
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212001', -- MASINHVIEN - varchar(40)
'THCS01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
6.5 -- DIEM - float
)
--11
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212002', -- MASINHVIEN - varchar(40)
'THCS01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
4 -- DIEM - float
)
--12
INSERT dbo.KETQUA
(
MASINHVIEN,
MAMONHOC,
LANTHI,
DIEM
)
VALUES
( '0212003', -- MASINHVIEN - varchar(40)
'THCS01', -- MAMONHOC - varchar(40)
1, -- LANTHI - int
7 -- DIEM - float
)
GO
Msg 547, Level 16, State 0, Line 337
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 351
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 365
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 379
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 393
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 407
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 421
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 435
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 449
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 463
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 477
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 491
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__KETQUA__MASINHVI__35BCFE0A". The conflict occurred in database "QUANLYSINHVIEN", table "dbo.MONHOC", column 'MAMONHOC'.
The statement has been terminated.