sql 函数 C#

sp_helptext Test1


--sp_helptext Test1



use DBTest;
go
if (object_id('Test2', 'P') is not null)
    drop proc Test2
go


、、、、
CREATE PROCEDURE testProc
    @out VARCHAR(500) OUTPUT
AS 
BEGIN
    SET @out='操作成功'
　　 RETURN
END


if (object_id('Test2', 'P') is not null)
    drop proc Test2
go
create proc Test2
	@ret decimal(8,2) OUTPUT,
	@i1 decimal(8,2),
	@i2 decimal(8,2)
as

begin 
   set @ret=dbo.Test1(@i1,@i2)
--select 2
   return
end


exec Test2 2.0,2.0;

--use DBTest;
--go
--create function Test1(@i1 decimal(4,2),@i2 decimal(4,2))
-- returns decimal(8,2)
--as
--begin 
-- return (@i1*@i2)
--end

class MyClass
{

    public static void Main()
    {

        System.Data.SqlClient.SqlConnection connection = new SqlConnection(@"Data Source=.;Initial Catalog=DBTest;Persist Security Info=True;User ID=sa;Password=1");
        System.Data.SqlClient.SqlCommand cmd = new SqlCommand("dbo.Test1", connection);
        cmd.CommandType = System.Data.CommandType.StoredProcedure;
        cmd.Parameters.Add("@i1", System.Data.SqlDbType.Decimal).Value = 2.25;
        cmd.Parameters.Add("@i2", System.Data.SqlDbType.Decimal).Value = 2.000;
        cmd.Parameters.Add("@ret",System.Data.SqlDbType.Decimal).Direction=System.Data.ParameterDirection.ReturnValue;

        connection.Open();
        cmd.ExecuteNonQuery();
        string ret=cmd.Parameters["@ret"]?.Value?.ToString();
        Console.WriteLine(ret);

        Pet[] pets = { new Pet { Name="Barley", Age=8 },
                   new Pet { Name="Boots", Age=4 },
                   new Pet { Name="Whiskers", Age=1 } };

        var min = pets.MinBy(pet => pet.Age);

        Console.WriteLine("The youngest animal is age {0}.", min);
    }
}