-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathBasicInvoiceData.sql
10 lines (9 loc) · 1.98 KB
/
BasicInvoiceData.sql
1
2
3
4
5
6
7
8
9
10
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (10000, N'Clothes', NULL, NULL)
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (11000, N'Male', NULL, 10000)
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (12000, N'Female', NULL, 10000)
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (12100, N'Skirt', NULL, 12000)
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (12110, N'Miniskirt', NULL, 12100)
INSERT [dbo].[Categories] ([ID], [Name], [Description], [ParentID]) VALUES (12200, N'Blouse', NULL, 12000)
INSERT [dbo].[Products] ([Name], [Description], [Price], [CategoryID]) VALUES (N'Red Blouse', NULL, 100.0000, 12200)
INSERT [dbo].[Products] ([Name], [Description], [Price], [CategoryID]) VALUES (N'Baby Clothes', NULL, 99.0000, 10000)
INSERT [dbo].[Products] ([Name], [Description], [Price], [CategoryID]) VALUES (N'Man''s Jacket (Pink)', NULL, 200.0000, 11000)