use master
go

IF DB_ID (N'lab12Grom') IS NOT NULL
DROP DATABASE lab12Grom
GO

CREATE DATABASE lab12Grom
GO
USE master;
GO

--удаление соединений
DECLARE @kill varchar(8000) = '';

SELECT @kill = @kill + 'KILL ' + CONVERT(varchar(5), c.session_id) + ';'
FROM sys.dm_exec_connections AS c
JOIN sys.dm_exec_sessions AS s
    ON c.session_id = s.session_id
WHERE c.session_id <> @@SPID
ORDER BY c.connect_time ASC

EXEC(@kill)
GO

USE lab12Grom
GO

IF OBJECT_ID(N'BookAuthors') IS NOT NULL
DROP TABLE BookAuthors
GO

CREATE TABLE BookAuthors(
	AuthorID INTEGER not null  PRIMARY KEY,
	FirstName varchar(30) not null,
	LastName varchar(30) not null,
	);

GO

INSERT BookAuthors
VALUES (1, 'Alexander', 'Pushkin'),
	(2, 'Taras', 'Shevchenko')
go

SELECT * FROM BookAuthors