Yurttas/PL/DBL/mssql/F/01/PC/Product-ins.sql

Revision as of 04:35, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">β†’β€ŽREM REM REM Product-ins.sql REM REM: INSERT INTO Product VALUES('A', '1001', 'pc'); INSERT INTO Product VAL...")
(diff) ← Older revision | Latest revision (diff) | Newer revision β†’ (diff)
 1/*
 2REM
 3REM
 4REM Product-ins.sql
 5REM
 6REM
 7*/
 8
 9INSERT INTO Product
10  VALUES('A', '1001', 'pc');
11
12INSERT INTO Product
13  VALUES('A', '1002', 'pc');
14
15INSERT INTO Product
16  VALUES('A', '1003', 'pc');
17
18INSERT INTO Product
19  VALUES('B', '1004', 'pc');
20
21INSERT INTO Product
22  VALUES('B', '1006', 'pc');
23
24INSERT INTO Product
25  VALUES('B', '3002', 'printer');
26
27INSERT INTO Product
28  VALUES('B', '3004', 'printer');
29
30INSERT INTO Product
31  VALUES('C', '1005', 'pc');
32
33INSERT INTO Product
34  VALUES('C', '1007', 'pc');
35
36INSERT INTO Product
37  VALUES('D', '1008', 'pc');
38
39INSERT INTO Product
40  VALUES('D', '1009', 'pc');
41
42INSERT INTO Product
43  VALUES('D', '1010', 'pc');
44
45INSERT INTO Product
46  VALUES('D', '2001', 'laptop');
47
48INSERT INTO Product
49  VALUES('D', '2002', 'laptop');
50
51INSERT INTO Product
52  VALUES('D', '2003', 'laptop');
53
54INSERT INTO Product
55  VALUES('D', '3001', 'printer');
56
57INSERT INTO Product
58  VALUES('D', '3003', 'printer');
59
60INSERT INTO Product
61  VALUES('E', '2004', 'laptop');
62
63INSERT INTO Product
64  VALUES('E', '2008', 'laptop');
65
66INSERT INTO Product
67  VALUES('F', '2005', 'laptop');
68
69INSERT INTO Product
70  VALUES('G', '2006', 'laptop');
71
72INSERT INTO Product
73  VALUES('G', '2007', 'laptop');
74
75INSERT INTO Product
76  VALUES('H', '3005', 'printer');
77
78INSERT INTO Product
79  VALUES('I', '3006', 'printer');