5btDrtg4

1USE master
2GO 
3
4IF  EXISTS (
5	SELECT name 
6		FROM sys.databases 
7		WHERE name = N'Uliana_lab1'
8)
9ALTER DATABASE [Uliana_lab1] set single_user with rollback immediate
10GO
11
12IF  EXISTS (
13	SELECT name 
14		FROM sys.databases 
15		WHERE name = N'Uliana_lab1'
16)
17DROP DATABASE [Uliana_lab1]
18GO
19
20CREATE DATABASE [Uliana_lab1]
21GO
22
23USE [Uliana_lab1]
24GO
25
26IF EXISTS(
27  SELECT *
28    FROM sys.schemas
29   WHERE name = N'Kvashnina1'
30) 
31 DROP SCHEMA Kvashnina1
32GO
33
34
35CREATE SCHEMA Kvashnina1 
36GO
37
38
39IF OBJECT_ID('[Uliana_lab1].Kvashnina1.izm', 'U') IS NOT NULL
40  DROP TABLE  [Uliana_lab1].Kvashnina1.izm
41GO
42
43
44CREATE TABLE [Uliana_lab1].Kvashnina1.izm
45(
46	Name VARCHAR(40) NULL, 
47	Izmer VARCHAR(40) NULL,
48)
49GO
50
51 INSERT INTO [Uliana_lab1].Kvashnina1.izm 
52 (Name,Izmer)
53 VALUES 
54 ( N'Temperature', N'Цельсий')
55 ,(N'Humidity', N'Проценты')
56 ,(N'Pressure', N'ММ ртутного столба')	
57 ,(N'Direction', N'Часть света')	
58 ,(N'Speed', N'Км.ч')	
59 ,(N'Precipitation', N'мм')
60  ,(N'RAdiation', N'эфективная доза')	
61GO	
62
63
64IF OBJECT_ID('[Uliana_lab1].Kvashnina1.station', 'U') IS NOT NULL
65  DROP TABLE  [Uliana_lab1].Kvashnina1.station
66GO
67
68
69CREATE TABLE [Uliana_lab1].Kvashnina1.station
70(
71	NameStation varchar(40) NULL, 
72)
73GO
74
75 INSERT INTO [Uliana_lab1].Kvashnina1.station 
76 (NameStation)
77 VALUES 
78 ( N'Им.Э.Т.Кренкеля,ГМО')
79 ,( N'Остров_Визе')
80 ,( N'Голомянный')
81 ,( N'Баренцбург')	
82 ,( N'Русский')
83 ,( N'Им.Е.К.Федорова,ГМО')	
84 ,( N'мыс_Желания ')	
85 ,( N'Стерлегова')	
86 ,( N'Остров_Диксон')	
87GO	
88SELECT * From [Uliana_lab1].Kvashnina1.station
89
90SELECT * From [Uliana_lab1].Kvashnina1.izm