Yurttas/PL/DBL/mssql/F/01/PC/I-all.sql

  1/*
  2REM
  3REM I-all.sql
  4REM
  5REM Insert into PC database tables.
  6REM
  7*/
  8
  9
 10/*
 11REM
 12REM
 13REM Product-ins.sql
 14REM
 15REM
 16*/
 17
 18INSERT INTO Product
 19  VALUES('A', '1001', 'pc');
 20
 21INSERT INTO Product
 22  VALUES('A', '1002', 'pc');
 23
 24INSERT INTO Product
 25  VALUES('A', '1003', 'pc');
 26
 27INSERT INTO Product
 28  VALUES('B', '1004', 'pc');
 29
 30INSERT INTO Product
 31  VALUES('B', '1006', 'pc');
 32
 33INSERT INTO Product
 34  VALUES('B', '3002', 'printer');
 35
 36INSERT INTO Product
 37  VALUES('B', '3004', 'printer');
 38
 39INSERT INTO Product
 40  VALUES('C', '1005', 'pc');
 41
 42INSERT INTO Product
 43  VALUES('C', '1007', 'pc');
 44
 45INSERT INTO Product
 46  VALUES('D', '1008', 'pc');
 47
 48INSERT INTO Product
 49  VALUES('D', '1009', 'pc');
 50
 51INSERT INTO Product
 52  VALUES('D', '1010', 'pc');
 53
 54INSERT INTO Product
 55  VALUES('D', '2001', 'laptop');
 56
 57INSERT INTO Product
 58  VALUES('D', '2002', 'laptop');
 59
 60INSERT INTO Product
 61  VALUES('D', '2003', 'laptop');
 62
 63INSERT INTO Product
 64  VALUES('D', '3001', 'printer');
 65
 66INSERT INTO Product
 67  VALUES('D', '3003', 'printer');
 68
 69INSERT INTO Product
 70  VALUES('E', '2004', 'laptop');
 71
 72INSERT INTO Product
 73  VALUES('E', '2008', 'laptop');
 74
 75INSERT INTO Product
 76  VALUES('F', '2005', 'laptop');
 77
 78INSERT INTO Product
 79  VALUES('G', '2006', 'laptop');
 80
 81INSERT INTO Product
 82  VALUES('G', '2007', 'laptop');
 83
 84INSERT INTO Product
 85  VALUES('H', '3005', 'printer');
 86
 87INSERT INTO Product
 88  VALUES('I', '3006', 'printer');
 89
 90
 91/*
 92REM
 93REM
 94REM PC-ins.sql
 95REM
 96REM
 97*/
 98
 99INSERT INTO PC
100  VALUES('1001', 133, 16, 1.6, '6x', 1595);
101
102INSERT INTO PC
103  VALUES('1002', 120, 16, 1.6, '6x', 1399);
104
105INSERT INTO PC
106  VALUES('1003', 166, 24, 2.5, '6x', 1899);
107
108INSERT INTO PC
109  VALUES('1004', 166, 32, 2.5, '8x', 1999);
110
111INSERT INTO PC
112  VALUES('1005', 166, 16, 2.0, '8x', 1999);
113
114INSERT INTO PC
115  VALUES('1006', 200, 32, 3.1, '8x', 2099);
116
117INSERT INTO PC
118  VALUES('1007', 200, 32, 3.2, '8x', 2349);
119
120INSERT INTO PC
121  VALUES('1008', 180, 32, 2.0, '8x', 3699);
122
123INSERT INTO PC
124  VALUES('1009', 200, 32, 2.5, '8x', 2599);
125
126INSERT INTO PC
127  VALUES('1010', 160, 16, 1.2, '8x', 2599);
128
129
130/*
131REM
132REM
133REM Laptop-ins.sql
134REM
135REM
136*/
137
138INSERT INTO Laptop
139  VALUES('2001', 100, 20, 1.10,  9.5, 1999);
140
141INSERT INTO Laptop
142  VALUES('2002', 117, 12, 0.75, 11.3, 2499);
143
144INSERT INTO Laptop
145  VALUES('2003', 117, 32, 1.00, 10.4, 3599);
146
147INSERT INTO Laptop
148  VALUES('2004', 133, 16, 1.10, 11.2, 3499);
149
150INSERT INTO Laptop
151  VALUES('2005', 133, 16, 1.00, 11.3, 2599);
152
153INSERT INTO Laptop
154  VALUES('2006', 120,  8, 0.81, 12.1, 1999);
155
156INSERT INTO Laptop
157  VALUES('2007', 150, 16, 1.35, 12.1, 4799);
158
159INSERT INTO Laptop
160  VALUES('2008', 120, 16, 1.10, 12.1, 2099);
161
162
163/*
164REM
165REM
166REM Printer-ins.sql
167REM
168REM
169*/
170
171INSERT INTO Printer
172  VALUES('3001', 'true', 'ink-jet', 275);
173
174INSERT INTO Printer
175  VALUES('3002', 'true', 'ink-jet', 269);
176
177INSERT INTO Printer
178  VALUES('3003', 'false', 'laser', 829);
179
180INSERT INTO Printer
181  VALUES('3004', 'false', 'laser', 879);
182
183INSERT INTO Printer
184  VALUES('3005', 'false', 'ink-jet', 180);
185
186INSERT INTO Printer
187  VALUES('3006', 'true', 'dry', 470);