SET DATEFORMAT DMY
INSERT dbo.HANGHOA
(
    ID,
    TENHANG,
    IDNHACUNGCAP,
    HANSUDUNG
)
VALUES
(   '6438689',   -- ID - varchar(20)
	N'Laptop HP Pravillion', -- TENHANG - nvarchar(40)
    '2751981', -- IDNHACUNGCAP - varchar(20)
    '16/09/2033'  -- HANSUDUNG - datetime
    )
INSERT dbo.HANGHOA
(
    ID,
    TENHANG,
    IDNHACUNGCAP,
    HANSUDUNG
)
VALUES
(   '1084358',   -- ID - varchar(20)
	N'Chảo chiên không dầu', -- TENHANG - nvarchar(40)
    '2887796638', -- IDNHACUNGCAP - varchar(20)
    '16/09/2032' -- HANSUDUNG - datetime
    )
INSERT dbo.HANGHOA
(
    ID,
    TENHANG,
    IDNHACUNGCAP,
    HANSUDUNG
)
VALUES
(   '33333333',   -- ID - varchar(20)
	N'Kem chống nắng', -- TENHANG - nvarchar(40)
    '899038', -- IDNHACUNGCAP - varchar(20)
    NULL -- HANSUDUNG - datetime
    )
INSERT dbo.HANGHOA
(
    ID,
    TENHANG,
    IDNHACUNGCAP,
    HANSUDUNG
)
VALUES
(   '2987106',   -- ID - varchar(20)
	N'Bếp điện hồng ngoại', -- TENHANG - nvarchar(40)
    '98768906', -- IDNHACUNGCAP - varchar(20)
    '27/5/2031' -- HANSUDUNG - datetime
    )
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

The statement has been terminated.
Msg 547, Level 16, State 0, Line 313
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__HANGHOA__IDDANHM__31EC6D26". The conflict occurred in database "QUANLYKHO", table "dbo.DANHMUC", column 'ID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 326
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__HANGHOA__IDDANHM__31EC6D26". The conflict occurred in database "QUANLYKHO", table "dbo.DANHMUC", column 'ID'.
The statement has been terminated.
1
2
3
4
5
6
7