Yurttas/PL/DBL/mssql/F/01/SPJ/Parts-ins.sql

 1/*
 2REM
 3REM
 4REM Parts-ins.sql
 5REM
 6REM
 7*/
 8
 9INSERT INTO Parts
10  VALUES('P01', 'Nut', 'Red', 12, 'Houston');
11
12INSERT INTO Parts
13  VALUES('P02', 'Nut', 'Blue', 18, 'Phoenix');
14
15INSERT INTO Parts
16  VALUES('P03', 'Cam', 'Blue', 22, 'Phoenix');
17
18INSERT INTO Parts
19  VALUES('P04', 'Cam', 'Red', 45, 'Atlanta');
20
21INSERT INTO Parts
22  VALUES('P05', 'Cam', 'Red', 18, 'Phoenix');
23
24INSERT INTO Parts
25  VALUES('P06', 'Cam', 'Yellow', 19, 'Phoenix');
26
27INSERT INTO Parts
28  VALUES('P07', 'Cog', 'Red', 59, 'Houston');
29
30INSERT INTO Parts
31  VALUES('P08', 'Cog', 'Red', 46, 'Houston');
32
33INSERT INTO Parts
34  VALUES('P09', 'Nut', 'Red', 22, 'Phoenix');
35
36INSERT INTO Parts
37  VALUES('P10', 'Nut', 'Yellow', 59, 'Houston');
38
39INSERT INTO Parts
40  VALUES('P11', 'Cam', 'Blue', 17, 'Atlanta');
41
42INSERT INTO Parts
43  VALUES('P12', 'Cog', 'Blue', 24, 'Atlanta');