åå¼å¤ªå¤§äºï¼ï¼SQL ä½¿ç¨ BIGINT ç±»åä¹åªè½æ¥å 20!
CREATE FUNCTION [dbo].[JC] (@n int)
RETURNS bigint AS
BEGIN
if @n>20 return 0
declare @Result bigint
if @n=1 SET @Result= 1
else SET @RESULT= @n*dbo.JC(@n-1)
RETURN @REsult
END
-------------------------------------------------------------------
CREATE FUNCTION [dbo].[TEST] (@n bigint)
RETURNS float(53) AS
BEGIN
if @n>20 return 0
declare @result float(53)
if @n=1 set @Result=(1.0*(dbo.jc(1)))/(1.0*(dbo.jc(3)))
else SET @Result=(1.0*(dbo.jc(2*@n-1)))/(1.0*(dbo.jc(2*@n+1)))+dbo.TEST(@n-1)
return @result
END
å®ä¹äº2个å½æ°ï¼è°ç¨ TEST å½æ°å³å¯
温馨提示:内容为网友见解,仅供参考