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)

转载于:https://www.cnblogs.com/resake/archive/2008/07/01/1232926.html