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

  1/*
  2REM
  3REM i-all
  4REM
  5REM Insert into Company-B database tables.
  6REM
  7*/
  8
  9/*
 10REM
 11REM
 12REM Employee-ins.sql
 13REM
 14REM
 15*/
 16
 17INSERT INTO Employee
 18  VALUES('Jeremy', '123-C Front', 'Austin');
 19
 20INSERT INTO Employee
 21  VALUES('Charles', '55 Main', 'Austin');
 22
 23INSERT INTO Employee
 24  VALUES('Jamie', '55 Main', 'Austin');
 25
 26INSERT INTO Employee
 27  VALUES('Casey', '251 Main', 'Austin');
 28
 29INSERT INTO Employee
 30  VALUES('Thomas', '158 Main', 'Houston');
 31
 32INSERT INTO Employee
 33  VALUES('Anthony', '37 North Star', 'Houston');
 34
 35INSERT INTO Employee
 36  VALUES('Benjamin', '414 Union', 'Houston');
 37
 38INSERT INTO Employee
 39  VALUES('Sara', '816 Back', 'Dallas');
 40
 41INSERT INTO Employee
 42  VALUES('David', '816 Back', 'Dallas');
 43
 44INSERT INTO Employee
 45  VALUES('Michael', '816 Back', 'Dallas');
 46
 47INSERT INTO Employee
 48  VALUES('Jennifer', '20 Second', 'Dallas');
 49
 50INSERT INTO Employee
 51  VALUES('Laura', '20 Second', 'Dallas');
 52
 53/*
 54REM
 55REM
 56REM Company-ins.sql
 57REM
 58REM
 59*/
 60
 61INSERT INTO Company
 62  VALUES('First Bank Corporation', 'Bryan');
 63
 64INSERT INTO Company
 65  VALUES('Small Bank Corporation', 'Houston');
 66
 67INSERT INTO Company
 68  VALUES('Minor Bank Corporation', 'Dallas');
 69
 70INSERT INTO Company
 71  VALUES('Major Bank Corporation', 'Dallas');
 72
 73/*
 74REM
 75REM
 76REM Works-ins.sql
 77REM
 78REM
 79*/
 80
 81INSERT INTO Works
 82  VALUES('Jeremy', 'First Bank Corporation', 100000);
 83
 84INSERT INTO Works
 85  VALUES('Charles', 'First Bank Corporation', 40000);
 86
 87INSERT INTO Works
 88  VALUES('Jamie', 'First Bank Corporation', 40000);
 89
 90INSERT INTO Works
 91  VALUES('Casey', 'First Bank Corporation', 30000);
 92
 93INSERT INTO Works
 94  VALUES('Thomas', 'Small Bank Corporation', 60000);
 95
 96INSERT INTO Works
 97  VALUES('Anthony', 'Small Bank Corporation', 60000);
 98
 99INSERT INTO Works
100  VALUES('Benjamin', 'Small Bank Corporation', 80000);
101
102INSERT INTO Works
103  VALUES('Sara', 'Minor Bank Corporation', 50000);
104
105INSERT INTO Works
106  VALUES('David', 'Minor Bank Corporation', 40000);
107
108INSERT INTO Works
109  VALUES('Michael', 'Major Bank Corporation', 30000);
110
111INSERT INTO Works
112  VALUES('Jennifer', 'Major Bank Corporation', 90000);
113
114/*
115REM
116REM
117REM Manages-ins.sql
118REM
119REM
120*/
121
122INSERT INTO Manages
123  VALUES('Jeremy', NULL);
124
125INSERT INTO Manages
126  VALUES('Charles', 'Jeremy');
127
128INSERT INTO Manages
129  VALUES('Jamie', 'Jeremy');
130
131INSERT INTO Manages
132  VALUES('Casey', 'Jeremy');
133
134INSERT INTO Manages
135  VALUES('Thomas', 'Benjamin');
136
137INSERT INTO Manages
138  VALUES('Anthony', 'Benjamin');
139
140INSERT INTO Manages
141  VALUES('Benjamin', NULL);
142
143INSERT INTO Manages
144  VALUES('Sara', NULL);
145
146INSERT INTO Manages
147  VALUES('David', 'Sara');
148
149INSERT INTO Manages
150  VALUES('Michael', 'Jennifer');
151
152INSERT INTO Manages
153  VALUES('Jennifer', NULL);