--Запрос 12
GO
CREATE PROCEDURE isFirstPolinom
@polID int
AS
declare @maxStep int;
SET @maxStep = (SELECT top 1 dbo.Polinom.Step  FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID
 and dbo.Polinom.Koif != 0 ORDER BY dbo.Polinom.Step DESC)

 DECLARE @value float = (SELECT top 1 dbo.Polinom.Koif FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID and dbo.Polinom.Step = 0)

SELECT IIF(@maxStep = 1, IIF(@value is NULL, 0,
 @value/(SELECT Koif FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID AND dbo.Polinom.Step = 1)
 ), NULL) as 'Корень либо NULL'

GO
EXEC isFirstPolinom 3

--Запрос 13

GO
CREATE PROCEDURE isSecondPolinom
@polID int
AS
declare @maxStep int;
SET @maxStep = (SELECT top 1 dbo.Polinom.Step  FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID
 and dbo.Polinom.Koif != 0 ORDER BY dbo.Polinom.Step DESC)

declare @a float, @b float, @c float
SET @a = (SELECT top 1 dbo.Polinom.Koif  FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID
and dbo.Polinom.Step = 2)

SET @b = (SELECT top 1 dbo.Polinom.Koif  FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID
and dbo.Polinom.Step = 1)

SET @c = (SELECT top 1 dbo.Polinom.Koif  FROM dbo.Polinom WHERE dbo.Polinom.ID = @polID
and dbo.Polinom.Step = 0)

--SELECT @a, @b, @c
SELECT IIF(@b*@b >= 4*@a*@c,
IIF(@b*@b = 4*@a*@c, CAST (-@b/(2*@a) as varchar(50)),
'x1:' + CAST ((-@b +SQRT( @b*@b - 4*@a*@c))/(2*@a) as varchar(50)) + '  '+
'x2:'+CAST ((-@b -SQRT( @b*@b - 4*@a*@c))/(2*@a) as varchar(50)) )
, 'NO Solution')
GO

EXEC isSecondPolinom 7