FOORUM: TABEL /PROTSEDUURID ulesanne

CREATE PROCEDURE lisaFilm
@Fnimi VARCHAR(50)
,@Faasta date
,@Fdirektor varchar(50)
,@Fzant varchar(20)
AS

BEGIN
INSERT INTO filmid(nimetus, aasta, direktor, zant)
VALUES (@Fnimi, @Faasta, @Fdirektor, @Fzant)
SELECT * FROM filmid;

END;

CREATE PROCEDURE FilmOts

@ots varchar(20)
AS;
BEGIN;
SELECT * FROM filmid
WHERE zant LIKE @ots + '%';
END;

CREATE PROCEDURE FilmUpdate
@Fzant varchar(20)
,@FimlID int
AS
BEGIN
SELECT * FROM filmid
UPDATE filmid SET zant=@Fzant
WHERE filmID = @FimlID;
SELECT * FROM filmid
END;

BEGIN
INSERT INTO filmid(nimetus, aasta, direktor, zant)
VALUES (Fnimi, Faasta, Fdirektor, Fzant);
SELECT * FROM filmid;

END

BEGIN
    SELECT * FROM filmid
    WHERE zant LIKE CONCAT(ots, '%');
END

BEGIN
    SELECT * FROM filmid;
    UPDATE filmid SET zant=Fzant
    WHERE filmID=id;
    SELECT * FROM filmid;
END