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)
if ((@MID<=@maximum) and (@MID>=@minimum))
	begin
		insert into Tipusok Values (@TNev,@MID)
		set @output = 1
	end
else
	begin
	set @output = 0
	/*print ("Hibas a kulsokulcsos megszoritas");*/
	end