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

--kontroll
EXEC FilmTypeLisamine 4, '10D', 'super filmid';

procedure lisamine

CREATE PROCEDURE filmtypeKustuta
@kustutumisID int
AS
Begin
	select * from filmtype;
	delete from filmtype
	where filmtypeID = @KustutumisID;
	select * from filmtype;
end

exec filmtypeKustuta 4;

procedure kustuda

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

otsing 1 taht procedure

CREATE PROCEDURE FilmtypeUuendamine
@id int,
@uusFilmtype varchar(250)
AS
BEGIN
    UPDATE filmtype
    SET filmtype = @uusFilmtype
    WHERE filmtypeID = @id;

    SELECT * FROM filmtype;
END

Taabeli Uuendamine

--Taabeli Kustutamine proceduriga
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
--kontroll
CREATE TABLE test(
testID int);
select * from test;
exec tablekustuta test;
select * from test;