Hỏi đáp

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

Đặt câu hỏi

Hỏi về sql

4 năm trước 456 lượt xem 0 bình luận

sql-server

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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168


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.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

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

VoTanDuc

Bài viết

Câu hỏi

Bình luận

240

Hỏi đáp

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

Hỏi về sql

Bình luận

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

AD BLOCKER DETECTED