代码
CREATE FUNCTION [dbo].[udf_PersonMachineExpressive]
(
@PersonExpressive DECIMAL(18,6),
@MachineExpressive DECIMAL(18,6)
)
RETURNS DECIMAL(18,6)
AS
BEGIN
DECLARE @ReturnValue DECIMAL(18,6)
SELECT @ReturnValue = (ISNULL(@PersonExpressive,0) * ISNULL(@MachineExpressive,0))
RETURN @ReturnValue
END
(
@PersonExpressive DECIMAL(18,6),
@MachineExpressive DECIMAL(18,6)
)
RETURNS DECIMAL(18,6)
AS
BEGIN
DECLARE @ReturnValue DECIMAL(18,6)
SELECT @ReturnValue = (ISNULL(@PersonExpressive,0) * ISNULL(@MachineExpressive,0))
RETURN @ReturnValue
END