Hỏi đáp

Chia sẻ kiến thức, cùng nhau phát triển

Hỏi về sql

13:52 28-06-2021 414 lượt xem 0 bình luậ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.

 

Bình luận

Để bình luận, bạn cần đăng nhập bằng tài khoản Howkteam.

Đăng nhập

Câu hỏi mới nhất