SQL Server 自定义函数实现传统四舍五入

CREATE OR ALTER FUNCTION dbo.LJH_TraditionalRound(@value DECIMAL(38,20), @decimals INT)
RETURNS DECIMAL(29,10)
AS
BEGIN
    DECLARE @factor DECIMAL(38,20) = POWER(10, @decimals)
    RETURN FLOOR(@value * @factor + 0.5) / @factor
END
GO