Oleksandra Ryshniak Portfolio

create procedure lisaFilmid
@lFilmiNimi varchar(40),
@rOsadeArv int
AS
Begin
insert into Filmid (FilmiNimi, OsadeArv)
Values(@lFilmiNimi, @rOsadeArv);
End;

exec lisaFilmid 'The Platform', 2

Create procedure lisaSkoor
@veerunimi varchar(20),
@tuup varchar (20) = null,
@valik varchar(20)

as
begin
declare @sqltegevus as varchar(max)
set @sqltegevus=case
when @valik='add' then concat('Alter table Filmid  Add ', @veerunimi, ' ', @tuup)
when @valik='drop' then concat('Alter table Filmid  drop column  ', @veerunimi)
end;
print @sqltegevus;
begin
exec (@sqltegevus);
end;
end;

exec  lisaSkoor @valik='add', @veerunimi='Skoor', @tuup='int';
select * from Filmid;

Create procedure FilmidOtsing
@taht char(1)
AS
begin
SELECT * from Filmid
Where FilmiNimi LIKE @taht + '%';
end;
EXEC FilmidOtsing T;