Yurttas/PL/DBL/mssql/F/01/Company-A/I-all.sql
Revision as of 04:28, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM i-all REM REM Insert into Company-A database tables. REM: →REM REM REM Employee-ins.sql REM REM: I...")
1/*
2REM
3REM i-all
4REM
5REM Insert into Company-A database tables.
6REM
7*/
8
9
10/*
11REM
12REM
13REM Employee-ins.sql
14REM
15REM
16*/
17
18INSERT INTO Employee
19 VALUES('John', 'B', 'Smith', '123456789', '09-JAN-55', '731 Fondren, Houston, TX', 'M', 30000, '333445555', '5');
20
21INSERT INTO Employee
22 VALUES('Franklin', 'T', 'Wong', '333445555', '08-DEC-45', '638 Voss, Houston, TX', 'M', 40000, '888665555', '5');
23
24INSERT INTO Employee
25 VALUES('Alicia', 'J', 'Zelaya', '999887777', '19-JUL-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', '4');
26
27INSERT INTO Employee
28 VALUES('Jennifer', 'S', 'Wallace', '987654321', '20-JUN-31', '291 Berry, Bellaire, TX', 'F', 43000, '888665555', '4');
29
30INSERT INTO Employee
31 VALUES('Ramesh', 'K', 'Narayan', '666884444', '15-SEP-52', '975 Fire Oak, Humble, TX', 'M', 38000, '333445555', '5');
32
33INSERT INTO Employee
34 VALUES('Joyce', 'A', 'English', '453453453', '31-JUL-62', '5631 Rice, Houston, TX', 'F', 25000, '333445555', '5');
35
36INSERT INTO Employee
37 VALUES('Ahmad', 'V', 'Jabbar', '987987987', '29-MAR-59', '980 Dallas, Houston, TX', 'M', 25000, '987654321', '4');
38
39INSERT INTO Employee
40 VALUES('James', 'E', 'Borg', '888665555', '10-NOV-27', '450 Stone, Houston, TX', 'M', 55000, null, '1');
41
42
43/*
44REM
45REM
46REM Dependent-ins.sql
47REM
48REM
49*/
50
51INSERT INTO Dependent
52 VALUES('333445555', 'Alice', 'F', '05-APR-76', 'DAUGHTER');
53
54INSERT INTO Dependent
55 VALUES('333445555', 'Theodore', 'M', '25-OCT-73', 'SON');
56
57INSERT INTO Dependent
58 VALUES('333445555', 'Joy', 'F', '03-MAY-48', 'SPOUSE');
59
60INSERT INTO Dependent
61 VALUES('987654321', 'Abner', 'M', '29-FEB-32', 'SPOUSE');
62
63INSERT INTO Dependent
64 VALUES('123456789', 'Michael', 'M', '01-JAN-78', 'SON');
65
66INSERT INTO Dependent
67 VALUES('123456789', 'Alice', 'F', '31-DEC-78', 'DAUGHTER');
68
69INSERT INTO Dependent
70 VALUES('123456789', 'Elizabeth', 'F', '05-MAY-57', 'SPOUSE');
71
72
73/*
74REM
75REM
76REM Department-ins.sql
77REM
78REM
79*/
80
81INSERT INTO Department
82 VALUES('Research', '5', '333445555', '22-MAY-78');
83
84INSERT INTO Department
85 VALUES('Administration', '4', '987654321', '01-JUN-85');
86
87INSERT INTO Department
88 VALUES('Headquarters', '1', '888665555', '19-JUN-71');
89
90
91/*
92REM
93REM
94REM DeptLocation-ins.sql
95REM
96REM
97*/
98
99INSERT INTO DeptLocation
100 VALUES('1', 'Houston');
101
102INSERT INTO DeptLocation
103 VALUES('4', 'Stafford');
104
105INSERT INTO DeptLocation
106 VALUES('5', 'Bellaire');
107
108INSERT INTO DeptLocation
109 VALUES('5', 'Sugarland');
110
111INSERT INTO DeptLocation
112 VALUES('5', 'Houston');
113
114
115/*
116REM
117REM
118REM Project-ins.sql
119REM
120REM
121*/
122
123INSERT INTO Project
124 VALUES('ProductX', '1', 'Bellaire', '5');
125
126INSERT INTO Project
127 VALUES('ProductY', '2', 'Sugarland', '5');
128
129INSERT INTO Project
130 VALUES('ProductZ', '3', 'Houston', '5');
131
132INSERT INTO Project
133 VALUES('Computerization', '10', 'Stafford', '4');
134
135INSERT INTO Project
136 VALUES('Reorganization', '20', 'Houston', '1');
137
138INSERT INTO Project
139 VALUES('Newbenefits', '30', 'Stafford', '4');
140
141
142/*
143REM
144REM
145REM WorksOn-ins.sql
146REM
147REM
148*/
149
150INSERT INTO WorksOn
151 VALUES('123456789', '1', 32.5);
152
153INSERT INTO WorksOn
154 VALUES('123456789', '2', 7.5);
155
156INSERT INTO WorksOn
157 VALUES('666884444', '3', 40.0);
158
159INSERT INTO WorksOn
160 VALUES('453453453', '1', 20.0);
161
162INSERT INTO WorksOn
163 VALUES('453453453', '2', 20.0);
164
165INSERT INTO WorksOn
166 VALUES('333445555', '2', 10.0);
167
168INSERT INTO WorksOn
169 VALUES('333445555', '3', 10.0);
170
171INSERT INTO WorksOn
172 VALUES('333445555', '10', 10.0);
173
174INSERT INTO WorksOn
175 VALUES('333445555', '20', 10.0);
176
177INSERT INTO WorksOn
178 VALUES('999887777', '30', 30.0);
179
180INSERT INTO WorksOn
181 VALUES('999887777', '10', 10.0);
182
183INSERT INTO WorksOn
184 VALUES('987987987', '10', 35.0);
185
186INSERT INTO WorksOn
187 VALUES('987987987', '30', 5.0);
188
189INSERT INTO WorksOn
190 VALUES('987654321', '30', 20.0);
191
192INSERT INTO WorksOn
193 VALUES('987654321', '20', 15.0);
194
195INSERT INTO WorksOn
196 VALUES('888665555', '20', 10.0);