CREATE PROCEDURE BeszurTipusok @TNev varchar(30), @MID int, @output int
as
DECLARE @minimum int;
DECLARE @maximum int;
DECLARE @id int;
Set @minimum = (Select MIN(MarkaID)
				From Markak)
Set @maximum = (Select MAX(MarkaID)
				From Markak)
Set @id = (Select MAX(Tipusok.TipusID)
			From Tipusok)
Set @id = @id +1
if ((@MID<=@maximum) and (@MID>=@minimum))
	begin
		insert into Tipusok Values (@id,@TNev,@MID)
		set @output = 1
	end
else
	begin
	set @output = 0
	print ("Hibas a kulsokulcsos megszoritas");
	end