1,1,2,3,5,8,13....的SQL SERVER实现

create function GetNum
(
@index int
)
returns int
as
begin
    
declare @count int
    
set @count = 0
    
if @index>=1 and @index<=2
        
set @count = 1
    
else
        
set @count = @count + dbo.GetNum(@index-1)+dbo.GetNum(@index-2)
    
return @count
end
go

print dbo.GetNum(30)
posted on 2008-07-01 11:39  resake  阅读(326)  评论(0)    收藏  举报