--计算10的阶乘
DECLARE @total INT
SELECT @total = ISNULL(@total, 1) * number
FROM MASTER.dbo.spt_values
WHERE TYPE = 'P'
AND number BETWEEN 1 AND 10
SELECT @total AS '的10阶乘'
--计算10的阶乘
DECLARE @total INT
SELECT @total = ISNULL(@total, 1) * number
FROM MASTER.dbo.spt_values
WHERE TYPE = 'P'
AND number BETWEEN 1 AND 10
SELECT @total AS '的10阶乘'