· 9 years ago · Oct 10, 2016, 07:08 AM
1CREATE DATABASE Zyryanov_Anton
2GO
3
4USE Zyryanov_Anton
5GO
6
7IF EXISTS(
8SELECT *
9FROM sys.schemas
10WHERE name = N'meteorology'
11)
12DROP SCHEMA meteorology
13GO
14
15CREATE SCHEMA meteorology
16GO
17
18IF OBJECT_ID('Zyryanov_Anton.meteorology.stations', 'U') IS NOT NULL
19DROP TABLE Zyryanov_Anton.meteorology.stations
20GO
21
22CREATE TABLE Zyryanov_Anton.meteorology.stations
23(
24station_id int NOT NULL,
25station_name nvarchar(120) NOT NULL,
26CONSTRAINT PK_station_id PRIMARY KEY (station_id)
27)
28GO
29
30
31IF OBJECT_ID('Zyryanov_Anton.meteorology.measure_types', 'U') IS NOT NULL
32DROP TABLE Zyryanov_Anton.meteorology.measure_types
33GO
34
35CREATE TABLE Zyryanov_Anton.meteorology.measure_types
36(
37measure_type_id int NOT NULL,
38measure_type_name nvarchar(40) NOT NULL,
39measure_type_units nvarchar(40) NOT NULL,
40CONSTRAINT PK_measure_type_id PRIMARY KEY (measure_type_id)
41)
42GO
43
44
45IF OBJECT_ID('Zyryanov_Anton.meteorology.measures', 'U') IS NOT NULL
46DROP TABLE Zyryanov_Anton.meteorology.measures
47GO
48CREATE TABLE Zyryanov_Anton.meteorology.measures
49(
50station_id int NOT NULL,
51measure_type_id int NOT NULL,
52measure_date datetime NOT NULL,
53measure_value float NOT NULL,
54comment nvarchar(120) NULL
55)
56GO
57
58ALTER TABLE Zyryanov_Anton.meteorology.measures
59ALTER COLUMN measure_date datetime NOT NULL
60GO
61
62ALTER TABLE Zyryanov_Anton.meteorology.measures ADD
63CONSTRAINT FK_station_id FOREIGN KEY (station_id)
64REFERENCES Zyryanov_Anton.meteorology.stations(station_id)
65ON UPDATE CASCADE
66GO
67
68ALTER TABLE Zyryanov_Anton.meteorology.measures ADD
69CONSTRAINT FK_measure_type_id FOREIGN KEY (measure_type_id)
70REFERENCES Zyryanov_Anton.meteorology.measure_types(measure_type_id)
71ON UPDATE CASCADE
72GO
73
74DELETE from Zyryanov_Anton.meteorology.measure_types
75GO
76
77DELETE from Zyryanov_Anton.meteorology.stations
78GO
79
80DELETE from Zyryanov_Anton.meteorology.measures
81
82INSERT INTO Zyryanov_Anton.meteorology.stations VALUES
83(1, N'ПервоуральÑк'), (2, N'Екатеринбург'), (3, N'ÐлапаевÑк'), (4, N'ÐовоÑибирÑк'), (5, 'Лондон'), (6, 'МоÑква')
84GO
85
86INSERT INTO Zyryanov_Anton.meteorology.measure_types VALUES
87(1, N'Температура', N'градуÑÑ‹ ЦельÑиÑ'),
88(2, N'ВлажноÑÑ‚ÑŒ', N'проценты'),
89(3, N'Давление', N'мм рт.ÑÑ‚.'),
90(4, N'Ðаправление ветра', N'угол'),
91(5, N'СкороÑÑ‚ÑŒ ветра', N'м/Ñ'),
92(6, N'ОÑадки', N'мм'),
93(7, N'Радиационный фон', N'мкР/ч');
94GO
95
96DELETE FROM Zyryanov_Anton.meteorology.measures
97
98INSERT INTO Zyryanov_Anton.meteorology.measures VALUES
99(1, 1, '09-10-2014', -12, NULL),
100(1, 2, '09-10-2014', 47, NULL),
101(1, 3, '09-10-2014', 709, NULL),
102(1, 4, '09-10-2014', 227, NULL),
103(1, 5, '09-10-2014', 27, NULL),
104(1, 6, '09-10-2014', 19, NULL),
105(1, 7, '09-10-2014', 5, NULL),
106(2, 1, '09-10-2014', -1, NULL),
107(2, 2, '09-10-2014', 83, NULL),
108(2, 3, '09-10-2014', 769, NULL),
109(2, 4, '09-10-2014', 103, NULL),
110(2, 5, '09-10-2014', 1, NULL),
111(2, 6, '09-10-2014', 22, NULL),
112(2, 7, '09-10-2014', 46, NULL),
113(3, 1, '09-10-2014', -5, NULL),
114(3, 2, '09-10-2014', 95, NULL),
115(3, 3, '09-10-2014', 783, NULL),
116(3, 4, '09-10-2014', 224, NULL),
117(3, 5, '09-10-2014', 11, NULL),
118(3, 6, '09-10-2014', 39, NULL),
119(3, 7, '09-10-2014', 56, NULL),
120(4, 1, '09-10-2014', 16, NULL),
121(4, 2, '09-10-2014', 45, NULL),
122(4, 3, '09-10-2014', 743, NULL),
123(4, 4, '09-10-2014', 74, NULL),
124(4, 5, '09-10-2014', 6, NULL),
125(4, 6, '09-10-2014', 36, NULL),
126(4, 7, '09-10-2014', 37, NULL),
127(1, 1, '09-10-2014', 27, NULL),
128(1, 2, '09-10-2014', 69, NULL),
129(1, 3, '09-10-2014', 791, NULL),
130(1, 4, '09-10-2014', 40, NULL),
131(1, 5, '09-10-2014', 11, NULL),
132(1, 6, '09-10-2014', 48, NULL),
133(1, 7, '09-10-2014', 13, NULL),
134(2, 1, '09-10-2014', 27, NULL),
135(2, 2, '09-10-2014', 82, NULL),
136(2, 3, '09-10-2014', 785, NULL),
137(2, 4, '09-10-2014', 99, NULL),
138(2, 5, '09-10-2014', 9, NULL),
139(2, 6, '09-10-2014', 5, NULL),
140(2, 7, '09-10-2014', 90, NULL),
141(3, 1, '09-10-2014', 4, NULL),
142(3, 2, '09-10-2014', 2, NULL),
143(3, 3, '09-10-2014', 703, NULL),
144(3, 4, '09-10-2014', 67, NULL),
145(3, 5, '09-10-2014', 1, NULL),
146(3, 6, '09-10-2014', 28, NULL),
147(3, 7, '09-10-2014', 1, NULL),
148(4, 1, '09-10-2014', 23, NULL),
149(4, 2, '09-10-2014', 35, NULL),
150(4, 3, '09-10-2014', 715, NULL),
151(4, 4, '09-10-2014', 354, NULL),
152(4, 5, '09-10-2014', 0, NULL),
153(4, 6, '09-10-2014', 20, NULL),
154(4, 7, '09-10-2014', 53, NULL),
155(1, 1, '09-10-2014', -29, NULL),
156(1, 2, '09-10-2014', 66, NULL),
157(1, 3, '09-10-2014', 742, NULL),
158(1, 4, '09-10-2014', 240, NULL),
159(1, 5, '09-10-2014', 21, NULL),
160(1, 6, '09-10-2014', 33, NULL),
161(1, 7, '09-10-2014', 54, NULL),
162(2, 1, '09-10-2014', -22, NULL),
163(2, 2, '09-10-2014', 78, NULL),
164(2, 3, '09-10-2014', 717, NULL),
165(2, 4, '09-10-2014', 254, NULL),
166(2, 5, '09-10-2014', 15, NULL),
167(2, 6, '09-10-2014', 16, NULL),
168(2, 7, '09-10-2014', 46, NULL),
169(3, 1, '09-10-2014', -23, NULL),
170(3, 2, '09-10-2014', 97, NULL),
171(3, 3, '09-10-2014', 734, NULL),
172(3, 4, '09-10-2014', 16, NULL),
173(3, 5, '09-10-2014', 21, NULL),
174(3, 6, '09-10-2014', 33, NULL),
175(3, 7, '09-10-2014', 19, NULL),
176(4, 1, '09-10-2014', -4, NULL),
177(4, 2, '09-10-2014', 39, NULL),
178(4, 3, '09-10-2014', 701, NULL),
179(4, 4, '09-10-2014', 58, NULL),
180(4, 5, '09-10-2014', 5, NULL),
181(4, 6, '09-10-2014', 18, NULL),
182(4, 7, '09-10-2014', 6, NULL),
183(1, 1, '09-10-2014', -11, NULL),
184(1, 2, '09-10-2014', 76, NULL),
185(1, 3, '09-10-2014', 712, NULL),
186(1, 4, '09-10-2014', 119, NULL),
187(1, 5, '09-10-2014', 18, NULL),
188(1, 6, '09-10-2014', 30, NULL),
189(1, 7, '09-10-2014', 94, NULL),
190(2, 1, '09-10-2014', -21, NULL),
191(2, 2, '09-10-2014', 42, NULL),
192(2, 3, '09-10-2014', 760, NULL),
193(2, 4, '09-10-2014', 231, NULL),
194(2, 5, '09-10-2014', 14, NULL),
195(2, 6, '09-10-2014', 18, NULL),
196(2, 7, '09-10-2014', 43, NULL),
197(3, 1, '09-10-2014', -16, NULL),
198(3, 2, '09-10-2014', 86, NULL),
199(3, 3, '09-10-2014', 748, NULL),
200(3, 4, '09-10-2014', 200, NULL),
201(3, 5, '09-10-2014', 7, NULL),
202(3, 6, '09-10-2014', 27, NULL),
203(3, 7, '09-10-2014', 76, NULL),
204(4, 1, '09-10-2014', -8, NULL),
205(4, 2, '09-10-2014', 80, NULL),
206(4, 3, '09-10-2014', 793, NULL),
207(4, 4, '09-10-2014', 121, NULL),
208(4, 5, '09-10-2014', 23, NULL),
209(4, 6, '09-10-2014', 17, NULL),
210(4, 7, '09-10-2014', 58, NULL),
211(1, 1, '09-10-2014', -15, NULL),
212(1, 2, '09-10-2014', 40, NULL),
213(1, 3, '09-10-2014', 750, NULL),
214(1, 4, '09-10-2014', 180, NULL),
215(1, 5, '09-10-2014', 10, NULL),
216(1, 6, '09-10-2014', 24, NULL),
217(1, 7, '09-10-2014', 80, NULL),
218(2, 1, '09-10-2014', -29, NULL),
219(2, 2, '09-10-2014', 4, NULL),
220(2, 3, '09-10-2014', 737, NULL),
221(2, 4, '09-10-2014', 328, NULL),
222(2, 5, '09-10-2014', 23, NULL),
223(2, 6, '09-10-2014', 25, NULL),
224(2, 7, '09-10-2014', 96, NULL),
225(3, 1, '09-10-2014', 2, NULL),
226(3, 2, '09-10-2014', 73, NULL),
227(3, 3, '09-10-2014', 740, NULL),
228(3, 4, '09-10-2014', 86, NULL),
229(3, 5, '09-10-2014', 9, NULL),
230(3, 6, '09-10-2014', 38, NULL),
231(3, 7, '09-10-2014', 19, NULL),
232(4, 1, '09-10-2014', 2, NULL),
233(4, 2, '09-10-2014', 53, NULL),
234(4, 3, '09-10-2014', 760, NULL),
235(4, 4, '09-10-2014', 333, NULL),
236(4, 5, '09-10-2014', 26, NULL),
237(4, 6, '09-10-2014', 14, NULL),
238(4, 7, '09-10-2014', 95, NULL),
239(1, 1, '09-10-2014', 27, NULL),
240(1, 2, '09-10-2014', 18, NULL),
241(1, 3, '09-10-2014', 799, NULL),
242(1, 4, '09-10-2014', 294, NULL),
243(1, 5, '09-10-2014', 8, NULL),
244(1, 6, '09-10-2014', 18, NULL),
245(1, 7, '09-10-2014', 90, NULL),
246(2, 1, '09-10-2014', -29, NULL),
247(2, 2, '09-10-2014', 10, NULL),
248(2, 3, '09-10-2014', 714, NULL),
249(2, 4, '09-10-2014', 45, NULL),
250(2, 5, '09-10-2014', 28, NULL),
251(2, 6, '09-10-2014', 31, NULL),
252(2, 7, '09-10-2014', 22, NULL),
253(3, 1, '09-10-2014', 18, NULL),
254(3, 2, '09-10-2014', 10, NULL),
255(3, 3, '09-10-2014', 764, NULL),
256(3, 4, '09-10-2014', 184, NULL),
257(3, 5, '09-10-2014', 0, NULL),
258(3, 6, '09-10-2014', 39, NULL),
259(3, 7, '09-10-2014', 83, NULL),
260(4, 1, '09-10-2014', -26, NULL),
261(4, 2, '09-10-2014', 53, NULL),
262(4, 3, '09-10-2014', 709, NULL),
263(4, 4, '09-10-2014', 162, NULL),
264(4, 5, '09-10-2014', 18, NULL),
265(4, 6, '09-10-2014', 19, NULL),
266(4, 7, '09-10-2014', 72, NULL),
267(1, 1, '09-10-2014', 22, NULL),
268(1, 2, '09-10-2014', 90, NULL),
269(1, 3, '09-10-2014', 757, NULL),
270(1, 4, '09-10-2014', 178, NULL),
271(1, 5, '09-10-2014', 5, NULL),
272(1, 6, '09-10-2014', 42, NULL),
273(1, 7, '09-10-2014', 6, NULL),
274(2, 1, '09-10-2014', 21, NULL),
275(2, 2, '09-10-2014', 37, NULL),
276(2, 3, '09-10-2014', 709, NULL),
277(2, 4, '09-10-2014', 168, NULL),
278(2, 5, '09-10-2014', 5, NULL),
279(2, 6, '09-10-2014', 3, NULL),
280(2, 7, '09-10-2014', 52, NULL),
281(3, 1, '09-10-2014', 8, NULL),
282(3, 2, '09-10-2014', 26, NULL),
283(3, 3, '09-10-2014', 711, NULL),
284(3, 4, '09-10-2014', 150, NULL),
285(3, 5, '09-10-2014', 4, NULL),
286(3, 6, '09-10-2014', 48, NULL),
287(3, 7, '09-10-2014', 72, NULL),
288(4, 1, '09-10-2014', -5, NULL),
289(4, 2, '09-10-2014', 96, NULL),
290(4, 3, '09-10-2014', 741, NULL),
291(4, 4, '09-10-2014', 284, NULL),
292(4, 5, '09-10-2014', 16, NULL),
293(4, 6, '09-10-2014', 6, NULL),
294(4, 7, '09-10-2014', 88, NULL),
295(1, 1, '09-10-2014', 9, NULL),
296(1, 2, '09-10-2014', 89, NULL),
297(1, 3, '09-10-2014', 736, NULL),
298(1, 4, '09-10-2014', 243, NULL),
299(1, 5, '09-10-2014', 30, NULL),
300(1, 6, '09-10-2014', 8, NULL),
301(1, 7, '09-10-2014', 14, NULL),
302(2, 1, '09-10-2014', -18, NULL),
303(2, 2, '09-10-2014', 56, NULL),
304(2, 3, '09-10-2014', 762, NULL),
305(2, 4, '09-10-2014', 249, NULL),
306(2, 5, '09-10-2014', 24, NULL),
307(2, 6, '09-10-2014', 8, NULL),
308(2, 7, '09-10-2014', 95, NULL),
309(3, 1, '09-10-2014', 13, NULL),
310(3, 2, '09-10-2014', 55, NULL),
311(3, 3, '09-10-2014', 704, NULL),
312(3, 4, '09-10-2014', 312, NULL),
313(3, 5, '09-10-2014', 23, NULL),
314(3, 6, '09-10-2014', 15, NULL),
315(3, 7, '09-10-2014', 43, NULL),
316(4, 1, '09-10-2014', -14, NULL),
317(4, 2, '09-10-2014', 98, NULL),
318(4, 3, '09-10-2014', 703, NULL),
319(4, 4, '09-10-2014', 160, NULL),
320(4, 5, '09-10-2014', 13, NULL),
321(4, 6, '09-10-2014', 49, NULL),
322(4, 7, '09-10-2014', 45, NULL),
323(1, 1, '09-10-2014', 26, NULL),
324(1, 2, '09-10-2014', 16, NULL),
325(1, 3, '09-10-2014', 770, NULL),
326(1, 4, '09-10-2014', 244, NULL),
327(1, 5, '09-10-2014', 23, NULL),
328(1, 6, '09-10-2014', 8, NULL),
329(1, 7, '09-10-2014', 20, NULL),
330(2, 1, '09-10-2014', -2, NULL),
331(2, 2, '09-10-2014', 72, NULL),
332(2, 3, '09-10-2014', 779, NULL),
333(2, 4, '09-10-2014', 68, NULL),
334(2, 5, '09-10-2014', 28, NULL),
335(2, 6, '09-10-2014', 19, NULL),
336(2, 7, '09-10-2014', 43, NULL),
337(3, 1, '09-10-2014', 12, NULL),
338(3, 2, '09-10-2014', 48, NULL),
339(3, 3, '09-10-2014', 772, NULL),
340(3, 4, '09-10-2014', 131, NULL),
341(3, 5, '09-10-2014', 25, NULL),
342(3, 6, '09-10-2014', 38, NULL),
343(3, 7, '09-10-2014', 69, NULL),
344(4, 1, '09-10-2014', -6, NULL),
345(4, 2, '09-10-2014', 36, NULL),
346(4, 3, '09-10-2014', 792, NULL),
347(4, 4, '09-10-2014', 281, NULL),
348(4, 5, '09-10-2014', 26, NULL),
349(4, 6, '09-10-2014', 22, NULL),
350(4, 7, '09-10-2014', 37, NULL),
351(1, 1, '09-10-2014', 24, NULL),
352(1, 2, '09-10-2014', 33, NULL),
353(1, 3, '09-10-2014', 723, NULL),
354(1, 4, '09-10-2014', 195, NULL),
355(1, 5, '09-10-2014', 5, NULL),
356(1, 6, '09-10-2014', 34, NULL),
357(1, 7, '09-10-2014', 26, NULL),
358(2, 1, '09-10-2014', -7, NULL),
359(2, 2, '09-10-2014', 92, NULL),
360(2, 3, '09-10-2014', 701, NULL),
361(2, 4, '09-10-2014', 13, NULL),
362(2, 5, '09-10-2014', 31, NULL),
363(2, 6, '09-10-2014', 37, NULL),
364(2, 7, '09-10-2014', 24, NULL),
365(3, 1, '09-10-2014', 19, NULL),
366(3, 2, '09-10-2014', 25, NULL),
367(3, 3, '09-10-2014', 767, NULL),
368(3, 4, '09-10-2014', 299, NULL),
369(3, 5, '09-10-2014', 29, NULL),
370(3, 6, '09-10-2014', 49, NULL),
371(3, 7, '09-10-2014', 57, NULL),
372(4, 1, '09-10-2014', -1, NULL),
373(4, 2, '09-10-2014', 30, NULL),
374(4, 3, '09-10-2014', 708, NULL),
375(4, 4, '09-10-2014', 223, NULL),
376(4, 5, '09-10-2014', 7, NULL),
377(4, 6, '09-10-2014', 37, NULL),
378(4, 7, '09-10-2014', 53, NULL),
379(1, 1, '09-10-2014', 17, NULL),
380(1, 2, '09-10-2014', 78, NULL),
381(1, 3, '09-10-2014', 789, NULL),
382(1, 4, '09-10-2014', 327, NULL),
383(1, 5, '09-10-2014', 22, NULL),
384(1, 6, '09-10-2014', 41, NULL),
385(1, 7, '09-10-2014', 56, NULL),
386(2, 1, '09-10-2014', -7, NULL),
387(2, 2, '09-10-2014', 55, NULL),
388(2, 3, '09-10-2014', 764, NULL),
389(2, 4, '09-10-2014', 256, NULL),
390(2, 5, '09-10-2014', 22, NULL),
391(2, 6, '09-10-2014', 8, NULL),
392(2, 7, '09-10-2014', 30, NULL),
393(3, 1, '09-10-2014', 3, NULL),
394(3, 2, '09-10-2014', 71, NULL),
395(3, 3, '09-10-2014', 732, NULL),
396(3, 4, '09-10-2014', 293, NULL),
397(3, 5, '09-10-2014', 0, NULL),
398(3, 6, '09-10-2014', 22, NULL),
399(3, 7, '09-10-2014', 58, NULL),
400(4, 1, '09-10-2014', -24, NULL),
401(4, 2, '09-10-2014', 24, NULL),
402(4, 3, '09-10-2014', 794, NULL),
403(4, 4, '09-10-2014', 325, NULL),
404(4, 5, '09-10-2014', 14, NULL),
405(4, 6, '09-10-2014', 40, NULL),
406(4, 7, '09-10-2014', 41, NULL),
407(1, 1, '09-10-2014', -29, NULL),
408(1, 2, '09-10-2014', 14, NULL),
409(1, 3, '09-10-2014', 792, NULL),
410(1, 4, '09-10-2014', 342, NULL),
411(1, 5, '09-10-2014', 29, NULL),
412(1, 6, '09-10-2014', 36, NULL),
413(1, 7, '09-10-2014', 59, NULL),
414(2, 1, '09-10-2014', -22, NULL),
415(2, 2, '09-10-2014', 11, NULL),
416(2, 3, '09-10-2014', 712, NULL),
417(2, 4, '09-10-2014', 99, NULL),
418(2, 5, '09-10-2014', 29, NULL),
419(2, 6, '09-10-2014', 34, NULL),
420(2, 7, '09-10-2014', 43, NULL),
421(3, 1, '09-10-2014', 11, NULL),
422(3, 2, '09-10-2014', 3, NULL),
423(3, 3, '09-10-2014', 711, NULL),
424(3, 4, '09-10-2014', 82, NULL),
425(3, 5, '09-10-2014', 26, NULL),
426(3, 6, '09-10-2014', 13, NULL),
427(3, 7, '09-10-2014', 94, NULL),
428(4, 1, '09-10-2014', 5, NULL),
429(4, 2, '09-10-2014', 75, NULL),
430(4, 3, '09-10-2014', 780, NULL),
431(4, 4, '09-10-2014', 71, NULL),
432(4, 5, '09-10-2014', 9, NULL),
433(4, 6, '09-10-2014', 47, NULL),
434(4, 7, '09-10-2014', 68, NULL),
435(1, 1, '09-10-2014', 2, NULL),
436(1, 2, '09-10-2014', 95, NULL),
437(1, 3, '09-10-2014', 700, NULL),
438(1, 4, '09-10-2014', 91, NULL),
439(1, 5, '09-10-2014', 0, NULL),
440(1, 6, '09-10-2014', 7, NULL),
441(1, 7, '09-10-2014', 36, NULL),
442(2, 1, '09-10-2014', -6, NULL),
443(2, 2, '09-10-2014', 72, NULL),
444(2, 3, '09-10-2014', 776, NULL),
445(2, 4, '09-10-2014', 270, NULL),
446(2, 5, '09-10-2014', 14, NULL),
447(2, 6, '09-10-2014', 35, NULL),
448(2, 7, '09-10-2014', 41, NULL),
449(3, 1, '09-10-2014', 5, NULL),
450(3, 2, '09-10-2014', 20, NULL),
451(3, 3, '09-10-2014', 753, NULL),
452(3, 4, '09-10-2014', 41, NULL),
453(3, 5, '09-10-2014', 24, NULL),
454(3, 6, '09-10-2014', 7, NULL),
455(3, 7, '09-10-2014', 41, NULL),
456(4, 1, '09-10-2014', -18, NULL),
457(4, 2, '09-10-2014', 82, NULL),
458(4, 3, '09-10-2014', 767, NULL),
459(4, 4, '09-10-2014', 227, NULL),
460(4, 5, '09-10-2014', 17, NULL),
461(4, 6, '09-10-2014', 23, NULL),
462(4, 7, '09-10-2014', 43, NULL),
463(1, 1, '09-10-2014', -7, NULL),
464(1, 2, '09-10-2014', 11, NULL),
465(1, 3, '09-10-2014', 775, NULL),
466(1, 4, '09-10-2014', 225, NULL),
467(1, 5, '09-10-2014', 25, NULL),
468(1, 6, '09-10-2014', 45, NULL),
469(1, 7, '09-10-2014', 60, NULL),
470(2, 1, '09-10-2014', -21, NULL),
471(2, 2, '09-10-2014', 11, NULL),
472(2, 3, '09-10-2014', 702, NULL),
473(2, 4, '09-10-2014', 320, NULL),
474(2, 5, '09-10-2014', 16, NULL),
475(2, 6, '09-10-2014', 3, NULL),
476(2, 7, '09-10-2014', 28, NULL),
477(3, 1, '09-10-2014', -12, NULL),
478(3, 2, '09-10-2014', 35, NULL),
479(3, 3, '09-10-2014', 747, NULL),
480(3, 4, '09-10-2014', 137, NULL),
481(3, 5, '09-10-2014', 18, NULL),
482(3, 6, '09-10-2014', 26, NULL),
483(3, 7, '09-10-2014', 99, NULL),
484(4, 1, '09-10-2014', 3, NULL),
485(4, 2, '09-10-2014', 26, NULL),
486(4, 3, '09-10-2014', 708, NULL),
487(4, 4, '09-10-2014', 196, NULL),
488(4, 5, '09-10-2014', 25, NULL),
489(4, 6, '09-10-2014', 13, NULL),
490(4, 7, '09-10-2014', 32, NULL),
491(1, 1, '09-10-2014', -23, NULL),
492(1, 2, '09-10-2014', 33, NULL),
493(1, 3, '09-10-2014', 762, NULL),
494(1, 4, '09-10-2014', 175, NULL),
495(1, 5, '09-10-2014', 21, NULL),
496(1, 6, '09-10-2014', 46, NULL),
497(1, 7, '09-10-2014', 1, NULL),
498(2, 1, '09-10-2014', 6, NULL),
499(2, 2, '09-10-2014', 0, NULL),
500(2, 3, '09-10-2014', 712, NULL),
501(2, 4, '09-10-2014', 238, NULL),
502(2, 5, '09-10-2014', 25, NULL),
503(2, 6, '09-10-2014', 40, NULL),
504(2, 7, '09-10-2014', 43, NULL),
505(3, 1, '09-10-2014', -26, NULL),
506(3, 2, '09-10-2014', 51, NULL),
507(3, 3, '09-10-2014', 722, NULL),
508(3, 4, '09-10-2014', 86, NULL),
509(3, 5, '09-10-2014', 2, NULL),
510(3, 6, '09-10-2014', 6, NULL),
511(3, 7, '09-10-2014', 90, NULL),
512(4, 1, '09-10-2014', -2, NULL),
513(4, 2, '09-10-2014', 20, NULL),
514(4, 3, '09-10-2014', 724, NULL),
515(4, 4, '09-10-2014', 349, NULL),
516(4, 5, '09-10-2014', 30, NULL),
517(4, 6, '09-10-2014', 22, NULL),
518(4, 7, '09-10-2014', 83, NULL);
519GO
520
521
522
523using System;
524using System.Collections.Generic;
525using System.Linq;
526using System.Text;
527using System.Threading.Tasks;
528using System.IO;
529using System.Security.Cryptography;
530
531namespace ConsoleApplication1
532{
533 class Program
534 {
535 static void Main(string[] args)
536 {
537 var f = new StreamWriter("out.txt");
538 var r = new Random(432534635);
539 for (int u = 0; u < 15; u++)
540 for (int i = 1; i <= 4; i++)
541 {
542 for (int j = 1; j <= 7; j++)
543 f.WriteLine(String.Format("({0}, {1}, '09-10-2014', {2}, NULL),", i, j, GetVal(j, r)));
544 }
545 f.Close();
546 }
547 static int GetVal(int i, Random r)
548 {
549 switch(i)
550 {
551 case 1:
552 return r.Next(-30, 30);
553 case 2:
554 return r.Next(0, 100);
555 case 3:
556 return r.Next(700, 800);
557 case 4:
558 return r.Next(0, 360);
559 case 5:
560 return r.Next(0, 32);
561 case 6:
562 return r.Next(0, 50);
563 case 7:
564 return r.Next(0, 100);
565 default:
566 return r.Next(0, 100);
567
568
569 }
570 }
571 }
572}