CREATE FUNCTION dbo.Add_Material_To_Model_F(@Model int)
RETURNS @result TABLE (No_Model int, No_Material int, Name_Material varchar( 20 ), In_Model int) AS
BEGIN
declare @res table (No_Model int, No_Material int, Name_Material varchar( 20 ), In_Model int)
insert into @res (No_Material, Name_Material) 
		select No_Material, Name_Material from dbo.Material
update @res set No_Model=@model
update @res set In_Model = - 1 
update @res set In_Model =  0  from dbo.Material_Model where NoLink_Model=No_Model and NoLink_Material=No_Material
insert  into @result 
	select * from @res
return
END