API tools faq
paste
Guest User

Untitled

a guest
Oct 18th, 2016
58
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 40.73 KB | None | 0 0
raw download clone embed print report
  1. USE [QLBanHangThietBiMayTinh]
  2. GO
  3. /****** Object:  Table [dbo].[TAIKHOAN]    Script Date: 10/18/2016 21:44:53 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. SET ANSI_PADDING ON
  9. GO
  10. CREATE TABLE [dbo].[TAIKHOAN](
  11.     [TenDangNhap] [VARCHAR](30) NOT NULL,
  12.     [MatKhau] [VARCHAR](20) NOT NULL,
  13.     [MaQuyenSuDung] [bit] NULL,
  14.  CONSTRAINT [PK_TAIKHOAN] PRIMARY KEY CLUSTERED
  15. (
  16.     [TenDangNhap] ASC
  17. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  18. ) ON [PRIMARY]
  19. GO
  20. SET ANSI_PADDING OFF
  21. GO
  22. INSERT [dbo].[TAIKHOAN] ([TenDangNhap], [MatKhau], [MaQuyenSuDung]) VALUES (N'admin', N'Admin1', 1)
  23. INSERT [dbo].[TAIKHOAN] ([TenDangNhap], [MatKhau], [MaQuyenSuDung]) VALUES (N'admin2', N'Admin2', 0)
  24. INSERT [dbo].[TAIKHOAN] ([TenDangNhap], [MatKhau], [MaQuyenSuDung]) VALUES (N'admin3', N'Admin3', 1)
  25. /****** Object:  Table [dbo].[KHACHHANG]    Script Date: 10/18/2016 21:44:53 ******/
  26. SET ANSI_NULLS ON
  27. GO
  28. SET QUOTED_IDENTIFIER ON
  29. GO
  30. SET ANSI_PADDING ON
  31. GO
  32. CREATE TABLE [dbo].[KHACHHANG](
  33.     [MaKH] [VARCHAR](13) NOT NULL,
  34.     [TenKH] [nvarchar](30) NOT NULL,
  35.     [DiaChi] [nvarchar](50) NULL,
  36.     [SoDienthoai] [VARCHAR](12) NULL,
  37.     [Email] [VARCHAR](30) NULL,
  38.     [GioiTinh] [nvarchar](8) NOT NULL,
  39.  CONSTRAINT [PK_KHACHHANG] PRIMARY KEY CLUSTERED
  40. (
  41.     [MaKH] ASC
  42. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  43. ) ON [PRIMARY]
  44. GO
  45. SET ANSI_PADDING OFF
  46. GO
  47. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH001', N'Trần Trọng An', N'369/41 Hồ Thị Nghĩa, P1, Q10, TPHCM', N'01222743738', N'trongan@gmail.com', N'Nam')
  48. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH002', N'Nguyễn Hải Bình', N'205/43 Tân Hòa Đông - P14 - Q6', N'0989145251', N'toctanchidia@yahoo.com', N'Nam')
  49. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH003', N'Hoàng Tiến Dũng', N'987/3b Lò Gốm - F8 - Q6', N'034.3520321', N'hdungbeat@yahoo.com', N'Nam')
  50. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH004', N'Nguyễn Kim Giang', N'541/17/2d Tỉnh Lộ 10 - Bình Tân', N'0953313333', N'nguyenkimgiang@yahoo.com', N'Nữ')
  51. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH005', N'Nguyễn Trường Giang', N'289/33 Bến Vân Đồn -F2 - Q4', N'0912153342', N'tgiang1979@yahoo.com', N'Nam')
  52. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH006', N'Nguyễn Thượng Hải', N'Thanh Trì - Hà Nội    ', N'0915188500', N'haint_itims2002@yahoo.com', N'Nam')
  53. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH007', N'Trịnh Thị Hằng', N'15/165 Đà Nẵng', N'0983373827', N'hang_polyme@yahoo.com', N'Nữ')
  54. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH008', N'Nguyễn Thị Thu Hằng', N'Thanh Trì - Hà Nội   ', N'0914363041', N'hangntt@vnu.edu.vn', N'Nữ')
  55. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH009', N'Nguyễn Thị Quỳnh Hoa', N'Bình Thạnh', N'04.37641359', N'quynhhoa_itims03@yahoo.com.vn', N'Nữ')
  56. INSERT [dbo].[KHACHHANG] ([MaKH], [TenKH], [DiaChi], [SoDienthoai], [Email], [GioiTinh]) VALUES (N'KH010', N'Nguyễn Quang Lịch', N'ĐHQG - KTX khu A Linh Trung Thủ Đức', N'0983797689', N'nqlich1501@yahoo.com', N'Nam')
  57. /****** Object:  Table [dbo].[CHUCVU]    Script Date: 10/18/2016 21:44:53 ******/
  58. SET ANSI_NULLS ON
  59. GO
  60. SET QUOTED_IDENTIFIER ON
  61. GO
  62. SET ANSI_PADDING ON
  63. GO
  64. CREATE TABLE [dbo].[CHUCVU](
  65.     [MaCV] [VARCHAR](13) NOT NULL,
  66.     [TenCV] [nvarchar](20) NOT NULL,
  67.  CONSTRAINT [PK_CHUCVU] PRIMARY KEY CLUSTERED
  68. (
  69.     [MaCV] ASC
  70. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  71. ) ON [PRIMARY]
  72. GO
  73. SET ANSI_PADDING OFF
  74. GO
  75. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV001', N'Nhân viên thu ngân')
  76. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV002', N'Nhân viên bán hàng')
  77. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV003', N'Thủ kho')
  78. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV004', N'Giám Đốc')
  79. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV005', N'Phó Giám Đốc')
  80. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV006', N'CT hội đồng quản trị')
  81. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV007', N'Nhân viên kiểm kê')
  82. INSERT [dbo].[CHUCVU] ([MaCV], [TenCV]) VALUES (N'CV008', N'Nhân viên kiểm kê')
  83. /****** Object:  Table [dbo].[NHACUNGCAP]    Script Date: 10/18/2016 21:44:53 ******/
  84. SET ANSI_NULLS ON
  85. GO
  86. SET QUOTED_IDENTIFIER ON
  87. GO
  88. SET ANSI_PADDING ON
  89. GO
  90. CREATE TABLE [dbo].[NHACUNGCAP](
  91.     [MaNCC] [VARCHAR](13) NOT NULL,
  92.     [TenNCC] [nvarchar](50) NOT NULL,
  93.     [DiaChi] [nvarchar](50) NULL,
  94.     [SoDienThoai] [VARCHAR](12) NULL,
  95.     [Fax] [VARCHAR](12) NULL,
  96.     [Email] [VARCHAR](30) NULL,
  97.  CONSTRAINT [PK_NHACUNGCAP] PRIMARY KEY CLUSTERED
  98. (
  99.     [MaNCC] ASC
  100. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  101. ) ON [PRIMARY]
  102. GO
  103. SET ANSI_PADDING OFF
  104. GO
  105. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC001', N'Công Ty TNHH Vi Tính Nguyên Kim Chính Nhân', N'Q. 1,Tp. Hồ Chí Minh (TPHCM)', N'0839203921', N'', N'cskh@chinhnhan.vn')
  106. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC002', N'Công Ty TNHH Phúc Tường', N' Tp. Thủ Dầu Một,Bình Dương', N'0908010077', N'', N'phuctuong@phuctuongitc.com.vn')
  107. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC003', N'Công Ty TNHH Điện Tử - Tin Học Từ Sơn', N' P. Kinh Dinh, TP. Phan Rang-Tháp Chàm,Ninh Thuận', N'0683822597', NULL, N'ts@tuson.vn')
  108. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC004', N'Công Ty TNHH Tin Học Tiên Phong', N'TP. Phan Thiết,Bình Thuận', N'0623838899', NULL, N'tienphong@itplaza.vn')
  109. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC005', N'Công Ty TNHH Minh Tiến', N'Q. Liên Chiểu,Tp. Đà Nẵng', N'05113730469', NULL, N'minhtiendanang@gmail.com')
  110. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC006', N'Công Ty TNHH TM DV XNK Phạm Nguyễn', N'Q. 1,Tp. Hồ Chí Minh (TPHCM)', N'0822109210', NULL, N'gd@gocnhinso.vn')
  111. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC007', N'Công Ty TNHH Một Thành Viên Tin Thành Long', N'Tp. Biên Hòa,Đồng Nai', N'0908937483', NULL, N'tinthanhlong@gmail.com')
  112. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC008', N'Công Ty TNHH Vi Tính Nguyên Kim', N'Q. 1,Tp. Hồ Chí Minh (TPHCM)', N'0839203191', NULL, N'sales@nguyenkimvn.com')
  113. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC009', N'Công Ty TNHH MTV Tin Học Hải Nguyên', N'Hòa Thành,Tây Ninh', N'0961556505', NULL, N'minhkha902@yahoo.com.vn')
  114. INSERT [dbo].[NHACUNGCAP] ([MaNCC], [TenNCC], [DiaChi], [SoDienThoai], [Fax], [Email]) VALUES (N'NCC010', N'Công Ty Cổ Phần Công Nghệ Liên Hiệp', N'Q. Tân Phú,Tp. Hồ Chí Minh (TPHCM)', N'0938707188', NULL, N'sale@sieuthicongnghe.com')
  115. /****** Object:  Table [dbo].[NHOMHANG]    Script Date: 10/18/2016 21:44:53 ******/
  116. SET ANSI_NULLS ON
  117. GO
  118. SET QUOTED_IDENTIFIER ON
  119. GO
  120. SET ANSI_PADDING ON
  121. GO
  122. CREATE TABLE [dbo].[NHOMHANG](
  123.     [MaNhom] [VARCHAR](13) NOT NULL,
  124.     [TenNhom] [nvarchar](50) NOT NULL,
  125.  CONSTRAINT [PK_NHOMHANG] PRIMARY KEY CLUSTERED
  126. (
  127.     [MaNhom] ASC
  128. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  129. ) ON [PRIMARY]
  130. GO
  131. SET ANSI_PADDING OFF
  132. GO
  133. INSERT [dbo].[NHOMHANG] ([MaNhom], [TenNhom]) VALUES (N'NH001', N'Laptop và máy tính bảng')
  134. INSERT [dbo].[NHOMHANG] ([MaNhom], [TenNhom]) VALUES (N'NH002', N'Máy tính và linh kiện')
  135. INSERT [dbo].[NHOMHANG] ([MaNhom], [TenNhom]) VALUES (N'NH003', N'Thiết bị văn phòng và moniter')
  136. INSERT [dbo].[NHOMHANG] ([MaNhom], [TenNhom]) VALUES (N'NH004', N'Phụ kiện công nghệ')
  137. INSERT [dbo].[NHOMHANG] ([MaNhom], [TenNhom]) VALUES (N'NH005', N'Thiết bị điện tử thông minh')
  138. /****** Object:  Table [dbo].[NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  139. SET ANSI_NULLS ON
  140. GO
  141. SET QUOTED_IDENTIFIER ON
  142. GO
  143. SET ANSI_PADDING ON
  144. GO
  145. CREATE TABLE [dbo].[NHANVIEN](
  146.     [MaNV] [VARCHAR](13) NOT NULL,
  147.     [TenNV] [nvarchar](50) NOT NULL,
  148.     [GioiTinh] [nvarchar](8) NOT NULL,
  149.     [SoDienThoai] [VARCHAR](12) NULL,
  150.     [NgaySinh] [DATE] NULL,
  151.     [Luong] [INT] NULL,
  152.     [SoCMTND] [VARCHAR](9) NOT NULL,
  153.     [TenDangNhap] [VARCHAR](30) NULL,
  154.     [NgayVaoLam] [DATE] NULL,
  155.     [MaCV] [VARCHAR](13) NULL,
  156.  CONSTRAINT [PK_NHANVIEN] PRIMARY KEY CLUSTERED
  157. (
  158.     [MaNV] ASC
  159. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  160. ) ON [PRIMARY]
  161. GO
  162. SET ANSI_PADDING OFF
  163. GO
  164. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV001', N'Nguyễn Thúy Hằng', N'Nữ', N'0909429495', CAST(0x201B0B00 AS DATE), 5000000, N'022230191', N'admin3', CAST(0xB7390B00 AS DATE), N'CV001')
  165. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV002', N' Lâm Sơn Kiệt', N'Nam', N'0988992518', CAST(0x9A1A0B00 AS DATE), 6000000, N'361740797', N'admin2', CAST(0xCC390B00 AS DATE), N'CV007')
  166. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV003', N'Phạm Quang Trường    ', N'Nam', N'01689525898', CAST(0xF3120B00 AS DATE), 5000000, N'331448201', N'admin2', CAST(0x49350B00 AS DATE), N'CV008')
  167. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV004', N'Bùi Thị Muôn  ', N'Nữ', N'01214907840', CAST(0xFD1D0B00 AS DATE), 6000000, N'340486509', N'admin2', CAST(0x6E390B00 AS DATE), N'CV002')
  168. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV005', N'Hà Văn Huyện', N'Nam', N'0939166160', CAST(0x46170B00 AS DATE), 6500000, N'371785980', N'admin3', CAST(0xB4390B00 AS DATE), N'CV003')
  169. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV006', N'Trần Văn Cao', N'Nam', N'0914409356', CAST(0x6D150B00 AS DATE), 6500000, N'371070033', NULL, CAST(0x29380B00 AS DATE), N'CV003')
  170. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV007', N'Tạ Quốc Thiện   ', N'Nam', N'0963939994', CAST(0x6D1B0B00 AS DATE), 6000000, N'021749297', N'admin3', CAST(0xB2390B00 AS DATE), N'CV002')
  171. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV008', N'Nguyễn Thị Mỹ', N'Nữ', N'0986716397', CAST(0xE50F0B00 AS DATE), 10000000, N'311371560', N'admin', CAST(0x88320B00 AS DATE), N'CV005')
  172. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV009', N'Nguyễn Chí Cường', N'Nam', N'0913133894', CAST(0xEC0E0B00 AS DATE), 15000000, N'320375615', N'admin', CAST(0x88320B00 AS DATE), N'CV004')
  173. INSERT [dbo].[NHANVIEN] ([MaNV], [TenNV], [GioiTinh], [SoDienThoai], [NgaySinh], [Luong], [SoCMTND], [TenDangNhap], [NgayVaoLam], [MaCV]) VALUES (N'NV010', N'Mai Minh Tuấn', N'Nam', N'0907094345', CAST(0xE9080B00 AS DATE), 20000000, N'361402178', N'admin', CAST(0x74320B00 AS DATE), N'CV006')
  174. /****** Object:  Table [dbo].[HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  175. SET ANSI_NULLS ON
  176. GO
  177. SET QUOTED_IDENTIFIER ON
  178. GO
  179. SET ANSI_PADDING ON
  180. GO
  181. CREATE TABLE [dbo].[HANGHOA](
  182.     [MaHH] [CHAR](13) NOT NULL,
  183.     [TenHH] [nvarchar](50) NOT NULL,
  184.     [ThuongHieu] [nvarchar](30) NULL,
  185.     [AnhDemo] [image] NULL,
  186.     [DonGia] [INT] NULL,
  187.     [DongSanPham] [nvarchar](30) NULL,
  188.     [ThongSoKyThuat] [nvarchar](30) NULL,
  189.     [GiamGia] [INT] NULL,
  190.     [NoiSanXuat] [nvarchar](30) NULL,
  191.     [MaNhom] [VARCHAR](13) NULL,
  192.     [MaNCC] [VARCHAR](13) NULL,
  193.  CONSTRAINT [PK_HANGHOA] PRIMARY KEY CLUSTERED
  194. (
  195.     [MaHH] ASC
  196. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  197. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  198. GO
  199. SET ANSI_PADDING OFF
  200. GO
  201. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000001', N'Laptop Asus K501LB - DM077D', N'Asus', NULL, 17500000, NULL, NULL, 100000, N'Việt Nam', N'NH001', N'NCC001')
  202. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000002', N'Laptop Asus K555LB - XX303D', N'Asus', NULL, 15000000, NULL, NULL, NULL, N'Việt Nam', N'NH001', N'NCC003')
  203. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000003', N'Lenovo Ideapad G510 5939-7789', N'Lenovo', NULL, 14000000, NULL, NULL, 1000000, N'Việt Nam', N'NH001', N'NCC001')
  204. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000004', N'Lenovo G480', N'Lenovo', NULL, 16550000, NULL, NULL, NULL, N'Việt Nam', N'NH001', N'NCC002')
  205. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000005', N'Laptop DellInspiron 3543 ', N'Dell', NULL, 17000000, NULL, NULL, 500000, N'Mỹ', N'NH001', N'NCC001')
  206. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000006', N'Samsung Galaxy Tab 4 8.0 3G 16GB', N'Samsung', NULL, 7000000, NULL, NULL, NULL, N'Việt Nam', N'NH001', N'NCC004')
  207. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000007', N'Màn hình 18.5"Asus VS197 DE BK/AP', N'Asus', NULL, 500000, NULL, NULL, NULL, N'Anh', N'NH003', N'NCC001')
  208. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000008', N'Key- Mouse Ensoho E113 Không dây', N'Ensoho', NULL, 300000, NULL, NULL, NULL, N'Việt Nam', N'NH002', N'NCC001')
  209. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000009', N'Key- Mouse Genius 8000 không dây', N'Genius', NULL, 300000, NULL, NULL, 50000, N'Anh', N'NH002', N'NCC010')
  210. INSERT [dbo].[HANGHOA] ([MaHH], [TenHH], [ThuongHieu], [AnhDemo], [DonGia], [DongSanPham], [ThongSoKyThuat], [GiamGia], [NoiSanXuat], [MaNhom], [MaNCC]) VALUES (N'HH00000000010', N'Mouse Jeway 1121', N'Jeway', NULL, 200000, NULL, NULL, NULL, N'Mỹ', N'NH002', N'NCC005')
  211. /****** Object:  UserDefinedFunction [dbo].[LayFullMatHang_NCC]    Script Date: 10/18/2016 21:44:56 ******/
  212. SET ANSI_NULLS ON
  213. GO
  214. SET QUOTED_IDENTIFIER ON
  215. GO
  216. CREATE FUNCTION [dbo].[LayFullMatHang_NCC]
  217. (  
  218.     @MaNCC NVARCHAR(30)
  219. )
  220. RETURNS TABLE
  221. AS
  222. RETURN
  223. (
  224.     SELECT     dbo.HANGHOA.MaHH, dbo.HANGHOA.TenHH, dbo.HANGHOA.ThuongHieu, dbo.HANGHOA.AnhDemo, dbo.HANGHOA.DonGia, dbo.HANGHOA.DongSanPham,
  225.                       dbo.HANGHOA.ThongSoKyThuat, dbo.HANGHOA.GiamGia, dbo.HANGHOA.NoiSanXuat
  226.     FROM         dbo.HANGHOA INNER JOIN
  227.                       dbo.NHACUNGCAP ON dbo.HANGHOA.MaNCC = dbo.NHACUNGCAP.MaNCC
  228.     WHERE NHACUNGCAP.MaNCC = @MaNCC
  229. )
  230. GO
  231. /****** Object:  UserDefinedFunction [dbo].[DanhSachHangHoa]    Script Date: 10/18/2016 21:44:56 ******/
  232. SET ANSI_NULLS ON
  233. GO
  234. SET QUOTED_IDENTIFIER ON
  235. GO
  236. CREATE FUNCTION [dbo].[DanhSachHangHoa]
  237. (  
  238.    
  239. )
  240. RETURNS TABLE
  241. AS
  242. RETURN
  243. (
  244.     SELECT HANGHOA.MaHH, HANGHOA.TenHH, HANGHOA.DonGia, NHOMHANG.TenNhom
  245.     FROM dbo.HANGHOA INNER JOIN dbo.NHOMHANG
  246.     ON NHOMHANG.MaNhom = HANGHOA.MaNhom
  247.     WHERE HANGHOA.DonGia > 6000000
  248. )
  249. GO
  250. /****** Object:  Table [dbo].[PHIEUXUAT]    Script Date: 10/18/2016 21:44:53 ******/
  251. SET ANSI_NULLS ON
  252. GO
  253. SET QUOTED_IDENTIFIER ON
  254. GO
  255. SET ANSI_PADDING ON
  256. GO
  257. CREATE TABLE [dbo].[PHIEUXUAT](
  258.     [MaPX] [INT] IDENTITY(1,1) NOT NULL,
  259.     [NgayXuat] [DATE] NULL,
  260.     [MaNV] [VARCHAR](13) NULL,
  261.     [MaKH] [VARCHAR](13) NULL,
  262.  CONSTRAINT [PK_PHIEUXUAT] PRIMARY KEY CLUSTERED
  263. (
  264.     [MaPX] ASC
  265. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  266. ) ON [PRIMARY]
  267. GO
  268. SET ANSI_PADDING OFF
  269. GO
  270. SET IDENTITY_INSERT [dbo].[PHIEUXUAT] ON
  271. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (1, CAST(0x82390B00 AS DATE), N'NV005', N'KH001')
  272. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (2, CAST(0x83390B00 AS DATE), N'NV006', N'KH009')
  273. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (3, CAST(0x83390B00 AS DATE), N'NV005', N'KH007')
  274. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (4, CAST(0x84390B00 AS DATE), N'NV006', N'KH001')
  275. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (5, CAST(0x85390B00 AS DATE), N'NV005', N'KH006')
  276. INSERT [dbo].[PHIEUXUAT] ([MaPX], [NgayXuat], [MaNV], [MaKH]) VALUES (6, CAST(0x86390B00 AS DATE), N'NV005', N'KH003')
  277. SET IDENTITY_INSERT [dbo].[PHIEUXUAT] OFF
  278. /****** Object:  Table [dbo].[PHIEUNHAP]    Script Date: 10/18/2016 21:44:53 ******/
  279. SET ANSI_NULLS ON
  280. GO
  281. SET QUOTED_IDENTIFIER ON
  282. GO
  283. SET ANSI_PADDING ON
  284. GO
  285. CREATE TABLE [dbo].[PHIEUNHAP](
  286.     [MaPN] [INT] IDENTITY(1,1) NOT NULL,
  287.     [NgayNhap] [DATE] NULL,
  288.     [MaNV] [VARCHAR](13) NULL,
  289.     [MaNCC] [VARCHAR](13) NULL,
  290.  CONSTRAINT [PK_PHIEUNHAP] PRIMARY KEY CLUSTERED
  291. (
  292.     [MaPN] ASC
  293. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  294. ) ON [PRIMARY]
  295. GO
  296. SET ANSI_PADDING OFF
  297. GO
  298. SET IDENTITY_INSERT [dbo].[PHIEUNHAP] ON
  299. INSERT [dbo].[PHIEUNHAP] ([MaPN], [NgayNhap], [MaNV], [MaNCC]) VALUES (1, CAST(0x77390B00 AS DATE), N'NV005', N'NCC001')
  300. INSERT [dbo].[PHIEUNHAP] ([MaPN], [NgayNhap], [MaNV], [MaNCC]) VALUES (2, CAST(0x78390B00 AS DATE), N'NV006', N'NCC002')
  301. INSERT [dbo].[PHIEUNHAP] ([MaPN], [NgayNhap], [MaNV], [MaNCC]) VALUES (3, CAST(0x78390B00 AS DATE), N'NV005', N'NCC003')
  302. INSERT [dbo].[PHIEUNHAP] ([MaPN], [NgayNhap], [MaNV], [MaNCC]) VALUES (4, CAST(0x8B390B00 AS DATE), N'NV006', N'NCC004')
  303. INSERT [dbo].[PHIEUNHAP] ([MaPN], [NgayNhap], [MaNV], [MaNCC]) VALUES (5, CAST(0x96390B00 AS DATE), N'NV005', N'NCC001')
  304. SET IDENTITY_INSERT [dbo].[PHIEUNHAP] OFF
  305. /****** Object:  Table [dbo].[PHIEUKIEMKE]    Script Date: 10/18/2016 21:44:53 ******/
  306. SET ANSI_NULLS ON
  307. GO
  308. SET QUOTED_IDENTIFIER ON
  309. GO
  310. SET ANSI_PADDING ON
  311. GO
  312. CREATE TABLE [dbo].[PHIEUKIEMKE](
  313.     [MaPKK] [INT] IDENTITY(1,1) NOT NULL,
  314.     [NgayKK] [DATE] NULL,
  315.     [MaNV] [VARCHAR](13) NULL,
  316.  CONSTRAINT [PK_PHIEUKIEMKE] PRIMARY KEY CLUSTERED
  317. (
  318.     [MaPKK] ASC
  319. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  320. ) ON [PRIMARY]
  321. GO
  322. SET ANSI_PADDING OFF
  323. GO
  324. SET IDENTITY_INSERT [dbo].[PHIEUKIEMKE] ON
  325. INSERT [dbo].[PHIEUKIEMKE] ([MaPKK], [NgayKK], [MaNV]) VALUES (1, CAST(0xAA390B00 AS DATE), N'NV002')
  326. INSERT [dbo].[PHIEUKIEMKE] ([MaPKK], [NgayKK], [MaNV]) VALUES (2, CAST(0xAA390B00 AS DATE), N'NV003')
  327. INSERT [dbo].[PHIEUKIEMKE] ([MaPKK], [NgayKK], [MaNV]) VALUES (3, CAST(0xAB390B00 AS DATE), N'NV002')
  328. INSERT [dbo].[PHIEUKIEMKE] ([MaPKK], [NgayKK], [MaNV]) VALUES (4, CAST(0xB2390B00 AS DATE), N'NV003')
  329. INSERT [dbo].[PHIEUKIEMKE] ([MaPKK], [NgayKK], [MaNV]) VALUES (5, CAST(0xDB390B00 AS DATE), N'NV002')
  330. SET IDENTITY_INSERT [dbo].[PHIEUKIEMKE] OFF
  331. /****** Object:  Table [dbo].[PHIEUBAOHANH]    Script Date: 10/18/2016 21:44:53 ******/
  332. SET ANSI_NULLS ON
  333. GO
  334. SET QUOTED_IDENTIFIER ON
  335. GO
  336. SET ANSI_PADDING ON
  337. GO
  338. CREATE TABLE [dbo].[PHIEUBAOHANH](
  339.     [MaPBH] [INT] IDENTITY(1,1) NOT NULL,
  340.     [ThoiGianBH] [CHAR](2) NULL,
  341.     [MaKH] [VARCHAR](13) NULL,
  342.     [MaHH] [CHAR](13) NULL,
  343.  CONSTRAINT [PK_PHIEUBAOHANH] PRIMARY KEY CLUSTERED
  344. (
  345.     [MaPBH] ASC
  346. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  347. ) ON [PRIMARY]
  348. GO
  349. SET ANSI_PADDING OFF
  350. GO
  351. SET IDENTITY_INSERT [dbo].[PHIEUBAOHANH] ON
  352. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (1, N'3T', N'KH001', N'HH00000000001')
  353. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (8, N'9T', N'KH002', N'HH00000000001')
  354. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (9, N'1N', N'KH004', N'HH00000000006')
  355. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (10, N'3N', N'KH004', N'HH00000000005')
  356. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (11, N'6T', N'KH010', N'HH00000000003')
  357. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (12, N'3T', N'KH008', N'HH00000000004')
  358. INSERT [dbo].[PHIEUBAOHANH] ([MaPBH], [ThoiGianBH], [MaKH], [MaHH]) VALUES (15, N'9T', N'KH005', N'HH00000000002')
  359. SET IDENTITY_INSERT [dbo].[PHIEUBAOHANH] OFF
  360. /****** Object:  Table [dbo].[HOADONBANHANG]    Script Date: 10/18/2016 21:44:53 ******/
  361. SET ANSI_NULLS ON
  362. GO
  363. SET QUOTED_IDENTIFIER ON
  364. GO
  365. SET ANSI_PADDING ON
  366. GO
  367. CREATE TABLE [dbo].[HOADONBANHANG](
  368.     [MaHD] [INT] IDENTITY(1,1) NOT NULL,
  369.     [NgayBan] [DATE] NULL,
  370.     [MaKH] [VARCHAR](13) NULL,
  371.     [MaNV] [VARCHAR](13) NULL,
  372.  CONSTRAINT [PK_HOADONBANHANG] PRIMARY KEY CLUSTERED
  373. (
  374.     [MaHD] ASC
  375. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  376. ) ON [PRIMARY]
  377. GO
  378. SET ANSI_PADDING OFF
  379. GO
  380. SET IDENTITY_INSERT [dbo].[HOADONBANHANG] ON
  381. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (1, CAST(0xA9390B00 AS DATE), N'KH001', N'NV001')
  382. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (2, CAST(0xA9390B00 AS DATE), N'KH002', N'NV001')
  383. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (3, CAST(0xAA390B00 AS DATE), N'KH001', N'NV003')
  384. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (4, CAST(0xA9390B00 AS DATE), N'KH003', N'NV003')
  385. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (5, CAST(0xAA390B00 AS DATE), N'KH005', N'NV003')
  386. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (6, CAST(0xA9390B00 AS DATE), N'KH010', N'NV001')
  387. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (7, CAST(0xAD390B00 AS DATE), N'KH006', N'NV001')
  388. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (8, CAST(0xB0390B00 AS DATE), N'KH002', N'NV003')
  389. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (9, CAST(0x3C380B00 AS DATE), N'KH008', N'NV001')
  390. INSERT [dbo].[HOADONBANHANG] ([MaHD], [NgayBan], [MaKH], [MaNV]) VALUES (10, CAST(0x45380B00 AS DATE), N'KH007', N'NV001')
  391. SET IDENTITY_INSERT [dbo].[HOADONBANHANG] OFF
  392. /****** Object:  UserDefinedFunction [dbo].[LayTuoi_NHANVIEN]    Script Date: 10/18/2016 21:44:56 ******/
  393. SET ANSI_NULLS ON
  394. GO
  395. SET QUOTED_IDENTIFIER ON
  396. GO
  397. CREATE FUNCTION [dbo].[LayTuoi_NHANVIEN]
  398. (
  399.     @MaNV NVARCHAR(30)
  400. )
  401. RETURNS INT
  402. AS
  403. BEGIN
  404.    
  405.     DECLARE @age INT
  406.    
  407.     SELECT @age = DATEDIFF(YEAR, NgaySinh, GETDATE())
  408.     FROM dbo.NHANVIEN
  409.     WHERE MaNV = @MaNV
  410.     RETURN @age
  411. END
  412. GO
  413. /****** Object:  UserDefinedFunction [dbo].[LayHoaDon_KHACHHANG]    Script Date: 10/18/2016 21:44:56 ******/
  414. SET ANSI_NULLS ON
  415. GO
  416. SET QUOTED_IDENTIFIER ON
  417. GO
  418. CREATE FUNCTION [dbo].[LayHoaDon_KHACHHANG]
  419. (  
  420.     @MaKH NVARCHAR(30)
  421. )
  422. RETURNS TABLE
  423. AS
  424. RETURN
  425. (
  426.    
  427.     SELECT     dbo.HOADONBANHANG.MaHD, dbo.HOADONBANHANG.NgayBan, dbo.HOADONBANHANG.MaKH, dbo.HOADONBANHANG.MaNV
  428.     FROM         dbo.HOADONBANHANG INNER JOIN
  429.                       dbo.KHACHHANG ON dbo.HOADONBANHANG.MaKH = dbo.KHACHHANG.MaKH
  430.     WHERE HOADONBANHANG.MaKH = @MaKH
  431. )
  432. GO
  433. /****** Object:  Table [dbo].[CT_PHIEUXUAT]    Script Date: 10/18/2016 21:44:53 ******/
  434. SET ANSI_NULLS ON
  435. GO
  436. SET QUOTED_IDENTIFIER ON
  437. GO
  438. SET ANSI_PADDING ON
  439. GO
  440. CREATE TABLE [dbo].[CT_PHIEUXUAT](
  441.     [MaPX] [INT] NOT NULL,
  442.     [MaHH] [CHAR](13) NOT NULL,
  443.     [SoLuong] [INT] NULL,
  444.     [DonGia] [INT] NULL,
  445.     [ThanhTien] [INT] NULL,
  446.  CONSTRAINT [PK_CT_PHIEUKIEMKIE] PRIMARY KEY CLUSTERED
  447. (
  448.     [MaPX] ASC,
  449.     [MaHH] ASC
  450. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  451. ) ON [PRIMARY]
  452. GO
  453. SET ANSI_PADDING OFF
  454. GO
  455. INSERT [dbo].[CT_PHIEUXUAT] ([MaPX], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (1, N'HH00000000001', 1, 16000000, 16000000)
  456. INSERT [dbo].[CT_PHIEUXUAT] ([MaPX], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (2, N'HH00000000006', 3, 40000000, 40000000)
  457. INSERT [dbo].[CT_PHIEUXUAT] ([MaPX], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (3, N'HH00000000007', 1, 17000000, 17000000)
  458. INSERT [dbo].[CT_PHIEUXUAT] ([MaPX], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (4, N'HH00000000009', 2, 300000, 300000)
  459. INSERT [dbo].[CT_PHIEUXUAT] ([MaPX], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (5, N'HH00000000010', 1, 200000, 200000)
  460. /****** Object:  Table [dbo].[CT_PHIEUNHAP]    Script Date: 10/18/2016 21:44:53 ******/
  461. SET ANSI_NULLS ON
  462. GO
  463. SET QUOTED_IDENTIFIER ON
  464. GO
  465. SET ANSI_PADDING ON
  466. GO
  467. CREATE TABLE [dbo].[CT_PHIEUNHAP](
  468.     [MaPN] [INT] NOT NULL,
  469.     [MaHH] [CHAR](13) NOT NULL,
  470.     [SoLuong] [INT] NULL,
  471.     [DonGia] [INT] NULL,
  472.     [ThanhTien] [INT] NULL,
  473.  CONSTRAINT [PK_CT_PHIEUNHAP] PRIMARY KEY CLUSTERED
  474. (
  475.     [MaPN] ASC,
  476.     [MaHH] ASC
  477. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  478. ) ON [PRIMARY]
  479. GO
  480. SET ANSI_PADDING OFF
  481. GO
  482. INSERT [dbo].[CT_PHIEUNHAP] ([MaPN], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (1, N'HH00000000004', 1, 17000000, 17000000)
  483. INSERT [dbo].[CT_PHIEUNHAP] ([MaPN], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (2, N'HH00000000003', 1, 16000000, 16000000)
  484. INSERT [dbo].[CT_PHIEUNHAP] ([MaPN], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (3, N'HH00000000002', 4, 200000, 200000)
  485. INSERT [dbo].[CT_PHIEUNHAP] ([MaPN], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (4, N'HH00000000003', 1, 500000, 500000)
  486. INSERT [dbo].[CT_PHIEUNHAP] ([MaPN], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (5, N'HH00000000008', 5, 30000000, 30000000)
  487. /****** Object:  Table [dbo].[CT_PHIEUKIEMKE]    Script Date: 10/18/2016 21:44:53 ******/
  488. SET ANSI_NULLS ON
  489. GO
  490. SET QUOTED_IDENTIFIER ON
  491. GO
  492. SET ANSI_PADDING ON
  493. GO
  494. CREATE TABLE [dbo].[CT_PHIEUKIEMKE](
  495.     [MaPKK] [INT] NOT NULL,
  496.     [MaHH] [CHAR](13) NOT NULL,
  497.     [SoLuong] [INT] NULL,
  498.     [DonGia] [INT] NULL,
  499.     [ThanhTien] [INT] NULL,
  500.  CONSTRAINT [PK_CT_PHIEUKIEMKE] PRIMARY KEY CLUSTERED
  501. (
  502.     [MaPKK] ASC,
  503.     [MaHH] ASC
  504. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  505. ) ON [PRIMARY]
  506. GO
  507. SET ANSI_PADDING OFF
  508. GO
  509. INSERT [dbo].[CT_PHIEUKIEMKE] ([MaPKK], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (1, N'HH00000000001', 5, 40000000, 40000000)
  510. INSERT [dbo].[CT_PHIEUKIEMKE] ([MaPKK], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (2, N'HH00000000003', 9, 50000000, 48000000)
  511. INSERT [dbo].[CT_PHIEUKIEMKE] ([MaPKK], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (3, N'HH00000000002', 10, 20000000, 19800000)
  512. INSERT [dbo].[CT_PHIEUKIEMKE] ([MaPKK], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (4, N'HH00000000008', 4, 54500000, 54500000)
  513. INSERT [dbo].[CT_PHIEUKIEMKE] ([MaPKK], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (5, N'HH00000000003', 6, 30000000, 30000000)
  514. /****** Object:  Table [dbo].[CT_HOADONBANHANG]    Script Date: 10/18/2016 21:44:53 ******/
  515. SET ANSI_NULLS ON
  516. GO
  517. SET QUOTED_IDENTIFIER ON
  518. GO
  519. SET ANSI_PADDING ON
  520. GO
  521. CREATE TABLE [dbo].[CT_HOADONBANHANG](
  522.     [MaHD] [INT] NOT NULL,
  523.     [MaHH] [CHAR](13) NOT NULL,
  524.     [SoLuong] [INT] NULL,
  525.     [DonGia] [INT] NULL,
  526.     [ThanhTien] [INT] NULL,
  527.  CONSTRAINT [PK_CT_HOADONBANHANG] PRIMARY KEY CLUSTERED
  528. (
  529.     [MaHD] ASC,
  530.     [MaHH] ASC
  531. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  532. ) ON [PRIMARY]
  533. GO
  534. SET ANSI_PADDING OFF
  535. GO
  536. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (1, N'HH00000000001', 2, 35000000, 32000000)
  537. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (2, N'HH00000000006', 3, 21000000, 21000000)
  538. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (3, N'HH00000000005', 7, 119000000, 117500000)
  539. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (4, N'HH00000000003', 3, 42000000, 39000000)
  540. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (5, N'HH00000000010', 8, 16000000, 16000000)
  541. INSERT [dbo].[CT_HOADONBANHANG] ([MaHD], [MaHH], [SoLuong], [DonGia], [ThanhTien]) VALUES (6, N'HH00000000008', 2, 600000, 600000)
  542. /****** Object:  UserDefinedFunction [dbo].[DanhSachNV_BanDuocHang]    Script Date: 10/18/2016 21:44:56 ******/
  543. SET ANSI_NULLS ON
  544. GO
  545. SET QUOTED_IDENTIFIER ON
  546. GO
  547. CREATE FUNCTION [dbo].[DanhSachNV_BanDuocHang]
  548. (  
  549.    
  550. )
  551. RETURNS TABLE
  552. AS
  553. RETURN
  554. (
  555.     SELECT dbo.NHANVIEN.TenNV,dbo.HOADONBANHANG.MaHD,dbo.CT_HOADONBANHANG.SoLuong
  556.     FROM dbo.NHANVIEN, dbo.HOADONBANHANG, dbo.CT_HOADONBANHANG
  557.     WHERE dbo.NHANVIEN.MaNV = dbo.HOADONBANHANG.MaNV
  558.         AND dbo.HOADONBANHANG.MaHD = dbo.CT_HOADONBANHANG.MaHD
  559. )
  560. GO
  561. /****** Object:  Default [DF_CT_HOADONBANHANG_SoLuong]    Script Date: 10/18/2016 21:44:53 ******/
  562. ALTER TABLE [dbo].[CT_HOADONBANHANG] ADD  CONSTRAINT [DF_CT_HOADONBANHANG_SoLuong]  DEFAULT ((1)) FOR [SoLuong]
  563. GO
  564. /****** Object:  Default [DF_CT_PHIEUKIEMKE_SoLuong]    Script Date: 10/18/2016 21:44:53 ******/
  565. ALTER TABLE [dbo].[CT_PHIEUKIEMKE] ADD  CONSTRAINT [DF_CT_PHIEUKIEMKE_SoLuong]  DEFAULT ((1)) FOR [SoLuong]
  566. GO
  567. /****** Object:  Default [DF_CT_PHIEUNHAP_SoLuong]    Script Date: 10/18/2016 21:44:53 ******/
  568. ALTER TABLE [dbo].[CT_PHIEUNHAP] ADD  CONSTRAINT [DF_CT_PHIEUNHAP_SoLuong]  DEFAULT ((1)) FOR [SoLuong]
  569. GO
  570. /****** Object:  Default [DF_CT_PHIEUXUAT_SoLuong]    Script Date: 10/18/2016 21:44:53 ******/
  571. ALTER TABLE [dbo].[CT_PHIEUXUAT] ADD  CONSTRAINT [DF_CT_PHIEUXUAT_SoLuong]  DEFAULT ((1)) FOR [SoLuong]
  572. GO
  573. /****** Object:  Default [DF_HANGHOA_DonGia]    Script Date: 10/18/2016 21:44:53 ******/
  574. ALTER TABLE [dbo].[HANGHOA] ADD  CONSTRAINT [DF_HANGHOA_DonGia]  DEFAULT ((1)) FOR [DonGia]
  575. GO
  576. /****** Object:  Default [DF_KHACHHANG_GioiTinh]    Script Date: 10/18/2016 21:44:53 ******/
  577. ALTER TABLE [dbo].[KHACHHANG] ADD  CONSTRAINT [DF_KHACHHANG_GioiTinh]  DEFAULT (N'Nữ') FOR [GioiTinh]
  578. GO
  579. /****** Object:  Default [DF_NHANVIEN_GioiTinh]    Script Date: 10/18/2016 21:44:53 ******/
  580. ALTER TABLE [dbo].[NHANVIEN] ADD  CONSTRAINT [DF_NHANVIEN_GioiTinh]  DEFAULT (N'Nữ') FOR [GioiTinh]
  581. GO
  582. /****** Object:  Check [CK_CT_HOADONBANHANG]    Script Date: 10/18/2016 21:44:53 ******/
  583. ALTER TABLE [dbo].[CT_HOADONBANHANG]  WITH CHECK ADD  CONSTRAINT [CK_CT_HOADONBANHANG] CHECK  (([DonGia]>(0)))
  584. GO
  585. ALTER TABLE [dbo].[CT_HOADONBANHANG] CHECK CONSTRAINT [CK_CT_HOADONBANHANG]
  586. GO
  587. /****** Object:  Check [CK_CT_PHIEUKIEMKE]    Script Date: 10/18/2016 21:44:53 ******/
  588. ALTER TABLE [dbo].[CT_PHIEUKIEMKE]  WITH CHECK ADD  CONSTRAINT [CK_CT_PHIEUKIEMKE] CHECK  (([DonGia]>(0)))
  589. GO
  590. ALTER TABLE [dbo].[CT_PHIEUKIEMKE] CHECK CONSTRAINT [CK_CT_PHIEUKIEMKE]
  591. GO
  592. /****** Object:  Check [CK_CT_PHIEUNHAP]    Script Date: 10/18/2016 21:44:53 ******/
  593. ALTER TABLE [dbo].[CT_PHIEUNHAP]  WITH CHECK ADD  CONSTRAINT [CK_CT_PHIEUNHAP] CHECK  (([DonGia]>(0)))
  594. GO
  595. ALTER TABLE [dbo].[CT_PHIEUNHAP] CHECK CONSTRAINT [CK_CT_PHIEUNHAP]
  596. GO
  597. /****** Object:  Check [CK_CT_PHIEUXUAT]    Script Date: 10/18/2016 21:44:53 ******/
  598. ALTER TABLE [dbo].[CT_PHIEUXUAT]  WITH CHECK ADD  CONSTRAINT [CK_CT_PHIEUXUAT] CHECK  (([DonGia]>(0)))
  599. GO
  600. ALTER TABLE [dbo].[CT_PHIEUXUAT] CHECK CONSTRAINT [CK_CT_PHIEUXUAT]
  601. GO
  602. /****** Object:  Check [CK_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  603. ALTER TABLE [dbo].[HANGHOA]  WITH CHECK ADD  CONSTRAINT [CK_HANGHOA] CHECK  (([DonGia]>(0)))
  604. GO
  605. ALTER TABLE [dbo].[HANGHOA] CHECK CONSTRAINT [CK_HANGHOA]
  606. GO
  607. /****** Object:  Check [CK_NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  608. ALTER TABLE [dbo].[NHANVIEN]  WITH CHECK ADD  CONSTRAINT [CK_NHANVIEN] CHECK  ((datediff(YEAR,[NgayVaoLam],getdate())>(0)))
  609. GO
  610. ALTER TABLE [dbo].[NHANVIEN] CHECK CONSTRAINT [CK_NHANVIEN]
  611. GO
  612. /****** Object:  Check [CK_PHIEUBAOHANH]    Script Date: 10/18/2016 21:44:53 ******/
  613. ALTER TABLE [dbo].[PHIEUBAOHANH]  WITH CHECK ADD  CONSTRAINT [CK_PHIEUBAOHANH] CHECK  (([ThoiGianBH]='3T' OR [ThoiGianBH]='6T' OR [ThoiGianBH]='6T' OR [ThoiGianBH]='9T' OR [ThoiGianBH]='1N' OR [ThoiGianBH]='3N'))
  614. GO
  615. ALTER TABLE [dbo].[PHIEUBAOHANH] CHECK CONSTRAINT [CK_PHIEUBAOHANH]
  616. GO
  617. /****** Object:  Check [CK_TAIKHOAN]    Script Date: 10/18/2016 21:44:53 ******/
  618. ALTER TABLE [dbo].[TAIKHOAN]  WITH CHECK ADD  CONSTRAINT [CK_TAIKHOAN] CHECK  (([MaQuyenSuDung]='True' OR [MaQuyenSuDung]='False'))
  619. GO
  620. ALTER TABLE [dbo].[TAIKHOAN] CHECK CONSTRAINT [CK_TAIKHOAN]
  621. GO
  622. /****** Object:  ForeignKey [FK_CT_HOADONBANHANG_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  623. ALTER TABLE [dbo].[CT_HOADONBANHANG]  WITH CHECK ADD  CONSTRAINT [FK_CT_HOADONBANHANG_HANGHOA] FOREIGN KEY([MaHH])
  624. REFERENCES [dbo].[HANGHOA] ([MaHH])
  625. GO
  626. ALTER TABLE [dbo].[CT_HOADONBANHANG] CHECK CONSTRAINT [FK_CT_HOADONBANHANG_HANGHOA]
  627. GO
  628. /****** Object:  ForeignKey [FK_CT_HOADONBANHANG_HOADONBANHANG]    Script Date: 10/18/2016 21:44:53 ******/
  629. ALTER TABLE [dbo].[CT_HOADONBANHANG]  WITH CHECK ADD  CONSTRAINT [FK_CT_HOADONBANHANG_HOADONBANHANG] FOREIGN KEY([MaHD])
  630. REFERENCES [dbo].[HOADONBANHANG] ([MaHD])
  631. GO
  632. ALTER TABLE [dbo].[CT_HOADONBANHANG] CHECK CONSTRAINT [FK_CT_HOADONBANHANG_HOADONBANHANG]
  633. GO
  634. /****** Object:  ForeignKey [FK_CT_PHIEUKIEMKE_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  635. ALTER TABLE [dbo].[CT_PHIEUKIEMKE]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUKIEMKE_HANGHOA] FOREIGN KEY([MaHH])
  636. REFERENCES [dbo].[HANGHOA] ([MaHH])
  637. GO
  638. ALTER TABLE [dbo].[CT_PHIEUKIEMKE] CHECK CONSTRAINT [FK_CT_PHIEUKIEMKE_HANGHOA]
  639. GO
  640. /****** Object:  ForeignKey [FK_CT_PHIEUKIEMKE_PHIEUKIEMKE]    Script Date: 10/18/2016 21:44:53 ******/
  641. ALTER TABLE [dbo].[CT_PHIEUKIEMKE]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUKIEMKE_PHIEUKIEMKE] FOREIGN KEY([MaPKK])
  642. REFERENCES [dbo].[PHIEUKIEMKE] ([MaPKK])
  643. GO
  644. ALTER TABLE [dbo].[CT_PHIEUKIEMKE] CHECK CONSTRAINT [FK_CT_PHIEUKIEMKE_PHIEUKIEMKE]
  645. GO
  646. /****** Object:  ForeignKey [FK_CT_PHIEUNHAP_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  647. ALTER TABLE [dbo].[CT_PHIEUNHAP]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUNHAP_HANGHOA] FOREIGN KEY([MaHH])
  648. REFERENCES [dbo].[HANGHOA] ([MaHH])
  649. GO
  650. ALTER TABLE [dbo].[CT_PHIEUNHAP] CHECK CONSTRAINT [FK_CT_PHIEUNHAP_HANGHOA]
  651. GO
  652. /****** Object:  ForeignKey [FK_CT_PHIEUNHAP_PHIEUNHAP]    Script Date: 10/18/2016 21:44:53 ******/
  653. ALTER TABLE [dbo].[CT_PHIEUNHAP]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUNHAP_PHIEUNHAP] FOREIGN KEY([MaPN])
  654. REFERENCES [dbo].[PHIEUNHAP] ([MaPN])
  655. GO
  656. ALTER TABLE [dbo].[CT_PHIEUNHAP] CHECK CONSTRAINT [FK_CT_PHIEUNHAP_PHIEUNHAP]
  657. GO
  658. /****** Object:  ForeignKey [FK_CT_PHIEUXUAT_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  659. ALTER TABLE [dbo].[CT_PHIEUXUAT]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUXUAT_HANGHOA] FOREIGN KEY([MaHH])
  660. REFERENCES [dbo].[HANGHOA] ([MaHH])
  661. GO
  662. ALTER TABLE [dbo].[CT_PHIEUXUAT] CHECK CONSTRAINT [FK_CT_PHIEUXUAT_HANGHOA]
  663. GO
  664. /****** Object:  ForeignKey [FK_CT_PHIEUXUAT_PHIEUXUAT]    Script Date: 10/18/2016 21:44:53 ******/
  665. ALTER TABLE [dbo].[CT_PHIEUXUAT]  WITH CHECK ADD  CONSTRAINT [FK_CT_PHIEUXUAT_PHIEUXUAT] FOREIGN KEY([MaPX])
  666. REFERENCES [dbo].[PHIEUXUAT] ([MaPX])
  667. GO
  668. ALTER TABLE [dbo].[CT_PHIEUXUAT] CHECK CONSTRAINT [FK_CT_PHIEUXUAT_PHIEUXUAT]
  669. GO
  670. /****** Object:  ForeignKey [FK_HANGHOA_NHACUNGCAP]    Script Date: 10/18/2016 21:44:53 ******/
  671. ALTER TABLE [dbo].[HANGHOA]  WITH CHECK ADD  CONSTRAINT [FK_HANGHOA_NHACUNGCAP] FOREIGN KEY([MaNCC])
  672. REFERENCES [dbo].[NHACUNGCAP] ([MaNCC])
  673. GO
  674. ALTER TABLE [dbo].[HANGHOA] CHECK CONSTRAINT [FK_HANGHOA_NHACUNGCAP]
  675. GO
  676. /****** Object:  ForeignKey [FK_HANGHOA_NHOMHANG]    Script Date: 10/18/2016 21:44:53 ******/
  677. ALTER TABLE [dbo].[HANGHOA]  WITH CHECK ADD  CONSTRAINT [FK_HANGHOA_NHOMHANG] FOREIGN KEY([MaNhom])
  678. REFERENCES [dbo].[NHOMHANG] ([MaNhom])
  679. GO
  680. ALTER TABLE [dbo].[HANGHOA] CHECK CONSTRAINT [FK_HANGHOA_NHOMHANG]
  681. GO
  682. /****** Object:  ForeignKey [FK_HOADONBANHANG_NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  683. ALTER TABLE [dbo].[HOADONBANHANG]  WITH CHECK ADD  CONSTRAINT [FK_HOADONBANHANG_NHANVIEN] FOREIGN KEY([MaNV])
  684. REFERENCES [dbo].[NHANVIEN] ([MaNV])
  685. GO
  686. ALTER TABLE [dbo].[HOADONBANHANG] CHECK CONSTRAINT [FK_HOADONBANHANG_NHANVIEN]
  687. GO
  688. /****** Object:  ForeignKey [FK_NHANVIEN_CHUCVU]    Script Date: 10/18/2016 21:44:53 ******/
  689. ALTER TABLE [dbo].[NHANVIEN]  WITH CHECK ADD  CONSTRAINT [FK_NHANVIEN_CHUCVU] FOREIGN KEY([MaCV])
  690. REFERENCES [dbo].[CHUCVU] ([MaCV])
  691. GO
  692. ALTER TABLE [dbo].[NHANVIEN] CHECK CONSTRAINT [FK_NHANVIEN_CHUCVU]
  693. GO
  694. /****** Object:  ForeignKey [FK_NHANVIEN_TAIKHOAN]    Script Date: 10/18/2016 21:44:53 ******/
  695. ALTER TABLE [dbo].[NHANVIEN]  WITH CHECK ADD  CONSTRAINT [FK_NHANVIEN_TAIKHOAN] FOREIGN KEY([TenDangNhap])
  696. REFERENCES [dbo].[TAIKHOAN] ([TenDangNhap])
  697. GO
  698. ALTER TABLE [dbo].[NHANVIEN] CHECK CONSTRAINT [FK_NHANVIEN_TAIKHOAN]
  699. GO
  700. /****** Object:  ForeignKey [FK_PHIEUBAOHANH_HANGHOA]    Script Date: 10/18/2016 21:44:53 ******/
  701. ALTER TABLE [dbo].[PHIEUBAOHANH]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUBAOHANH_HANGHOA] FOREIGN KEY([MaHH])
  702. REFERENCES [dbo].[HANGHOA] ([MaHH])
  703. GO
  704. ALTER TABLE [dbo].[PHIEUBAOHANH] CHECK CONSTRAINT [FK_PHIEUBAOHANH_HANGHOA]
  705. GO
  706. /****** Object:  ForeignKey [FK_PHIEUBAOHANH_KHACHHANG]    Script Date: 10/18/2016 21:44:53 ******/
  707. ALTER TABLE [dbo].[PHIEUBAOHANH]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUBAOHANH_KHACHHANG] FOREIGN KEY([MaKH])
  708. REFERENCES [dbo].[KHACHHANG] ([MaKH])
  709. GO
  710. ALTER TABLE [dbo].[PHIEUBAOHANH] CHECK CONSTRAINT [FK_PHIEUBAOHANH_KHACHHANG]
  711. GO
  712. /****** Object:  ForeignKey [FK_PHIEUKIEMKE_NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  713. ALTER TABLE [dbo].[PHIEUKIEMKE]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUKIEMKE_NHANVIEN] FOREIGN KEY([MaNV])
  714. REFERENCES [dbo].[NHANVIEN] ([MaNV])
  715. GO
  716. ALTER TABLE [dbo].[PHIEUKIEMKE] CHECK CONSTRAINT [FK_PHIEUKIEMKE_NHANVIEN]
  717. GO
  718. /****** Object:  ForeignKey [FK_PHIEUNHAP_NHACUNGCAP]    Script Date: 10/18/2016 21:44:53 ******/
  719. ALTER TABLE [dbo].[PHIEUNHAP]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUNHAP_NHACUNGCAP] FOREIGN KEY([MaNCC])
  720. REFERENCES [dbo].[NHACUNGCAP] ([MaNCC])
  721. GO
  722. ALTER TABLE [dbo].[PHIEUNHAP] CHECK CONSTRAINT [FK_PHIEUNHAP_NHACUNGCAP]
  723. GO
  724. /****** Object:  ForeignKey [FK_PHIEUNHAP_NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  725. ALTER TABLE [dbo].[PHIEUNHAP]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUNHAP_NHANVIEN] FOREIGN KEY([MaNV])
  726. REFERENCES [dbo].[NHANVIEN] ([MaNV])
  727. GO
  728. ALTER TABLE [dbo].[PHIEUNHAP] CHECK CONSTRAINT [FK_PHIEUNHAP_NHANVIEN]
  729. GO
  730. /****** Object:  ForeignKey [FK_PHIEUXUAT_KHACHHANG]    Script Date: 10/18/2016 21:44:53 ******/
  731. ALTER TABLE [dbo].[PHIEUXUAT]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUXUAT_KHACHHANG] FOREIGN KEY([MaKH])
  732. REFERENCES [dbo].[KHACHHANG] ([MaKH])
  733. GO
  734. ALTER TABLE [dbo].[PHIEUXUAT] CHECK CONSTRAINT [FK_PHIEUXUAT_KHACHHANG]
  735. GO
  736. /****** Object:  ForeignKey [FK_PHIEUXUAT_NHANVIEN]    Script Date: 10/18/2016 21:44:53 ******/
  737. ALTER TABLE [dbo].[PHIEUXUAT]  WITH CHECK ADD  CONSTRAINT [FK_PHIEUXUAT_NHANVIEN] FOREIGN KEY([MaNV])
  738. REFERENCES [dbo].[NHANVIEN] ([MaNV])
  739. GO
  740. ALTER TABLE [dbo].[PHIEUXUAT] CHECK CONSTRAINT [FK_PHIEUXUAT_NHANVIEN]
  741. GO
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!