CREATE FUNCTION fun_plus(@a INT)
RETURNS BIGINT
AS
BEGIN
DECLARE @b BIGINT
SET @b = 1
WHILE @a > 1
BEGIN
SET @b = @b * @a
SET @a = @a - 1
END
RETURN(@b)
END
RETURNS BIGINT
AS
BEGIN
DECLARE @b BIGINT
SET @b = 1
WHILE @a > 1
BEGIN
SET @b = @b * @a
SET @a = @a - 1
END
RETURN(@b)
END
没有测试跑你的语句