Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use master;
- go
- if DB_ID (N'lab12') is not null
- drop database lab12;
- go
- create database lab12
- on (
- NAME = lab12dat,
- FILENAME = 'C:\DB\lab12\lab12dat.mdf',
- SIZE = 10,
- MAXSIZE = 25,
- FILEGROWTH = 5
- )
- log on (
- NAME = lab12log,
- FILENAME = 'C:\DB\lab12\lab12log.ldf',
- SIZE = 5,
- MAXSIZE = 20,
- FILEGROWTH = 5
- );
- go
- use lab12;
- go
- if OBJECT_ID(N'Squad',N'U') is NOT NULL
- DROP TABLE Squad;
- go
- CREATE TABLE Squad (
- Squad_ID int IDENTITY(1,1) PRIMARY KEY,
- Surname char(30) NOT NULL,
- Name char(30) NOT NULL,
- Position char(3),
- Number numeric(2)
- );
- go
- INSERT INTO Squad(Surname,Name,Position, Number)
- VALUES (N'Аррисабалага',N'Кепа', N'ВРТ', 1),
- (N'Алонсо',N'Маркос', N'ЛЗ', 3),
- (N'Рюдигер',N'Антонио', N'ЦЗ', 2),
- (N'Томори',N'Фикайо', N'ЦЗ', 29),
- (N'Аспиликуэта',N'Сесар', N'ПЗ', 28),
- (N'Канте',N'Н’Голо', N'ЦПЗ', 7),
- (N'Маунт',N'Мейсон', N'ЦАП', 19),
- (N'Абрахам',N'Тэмми', N'ФРВ', 9),
- (N'Пулишич',N'Кристиан', N'ЛФА', 22)
- go
- SELECT * FROM Squad
- go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement