-Функция добавление фильма:

CREATE PROCEDURE filmTypeLisamine
@id int,
@type varchar(100),
@kirjeldus TEXT
AS
BEGIN
INSERT INTO filmtype (filmTypeID, filmType, kirjeldus)
VALUES (@id, @type, @kirjeldus);
SELECT * FROM filmtype;

END

->

-Удаление фильма

CREATE PROCEDURE filmTypeKustuta
@kustutumisID int
AS
BEGIN
SELECT * FROM filmtype;
DELETE FROM filmtype
WHERE filmtypeID = @kustutumisID;
SELECT * FROM filmtype;
END;

EXEC filmTypeKustuta 4;

-Обновляет данные таблицы

CREATE PROCEDURE filmTypeUendamine
@id int,
@uusfilmType varchar(100)
AS
Begin
UPDATE filmtype
SET filmtype = @uusfilmType
WHERE filmTypeID = @id;
SELECT * FROM filmtype;
END

-поиск по 1 букве

CREATE PROCEDURE otsing1taht
@taht CHAR(1)
AS
BEGIN
SELECT filmtype, kirjeldus
FROM filmtype
WHERE filmtype like concat (@taht, ‘%’);
END

1) Добавление режиссера

CREATE PROCEDURE rezisoorLisamine

@id int,
@eesnimi varchar(100),
@perenimi TEXT
AS
BEGIN
INSERT INTO rezisoor (rezisoorID, eesnimi, perenimi)
VALUES (@id, @eesnimi, @perenimi);
SELECT * FROM rezisoor;
END

2)Удаление жанра

CREATE PROCEDURE zanrKustuta

@kustutumisID int
AS
BEGIN
SELECT * FROM zanr;
DELETE FROM zanr
WHERE zanrID = @kustutumisID;
SELECT * FROM zanr;
END;

3)

Создал таблицу для удаления

Create PROCEDURE tablekustuta
@tableKustutamine varchar(100)
AS
BEGIN
declare @STMT as varchar(max)
SET @STMT=concat(‘DROP TABLE’, @tableKustutamine);
END;
PRINT @STMT;
BEGIN
EXEC(@STMT);
END