Herkese merhaba,
Bu kısımda SQL Server’da fibonacci serisini bulan fonksiyon kodları olacak.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
create function fn_generate_fibonacciseries(@number int) returns @returntable table (rownum int,fibonum int) as begin ;with fibonacciseries as ( select 1 as rownum, cast(0 as float) as start, cast(1 as float) as [next] union all select rownum+1, [next], start+[next] from fibonacciseries where rownum<=@number) Insert into @returntable(rownum,fibonum) select rownum,convert(numeric(38,0),cast(start AS float)) from fibonacciseries return end go --Çalıştırılması select * from dbo.fn_generate_fibonacciseries(10) |
