Fibonacci numbers (T-SQL)

From LiteratePrograms

The Fibonacci numbers are the integer sequence 0, 1, 1, 2, 3, 5, 8, 13, 21, ..., in which each item is formed by adding the previous two. The sequence can be defined recursively by

1 \\ \end{cases} ."/>

Fibonacci number programs that implement this definition directly are often used as introductory examples of recursion. However, many other algorithms for calculating (or making use of) Fibonacci numbers also exist.

In this article we show how to calculate Fibonacci numbers in T-SQL

Implementation

declare @a int
declare @b int
declare @fib int
set @a = 0
set @b = 1
set @fib = 0
print @a
print @b
while @fib < 1000
begin
	set @fib = @a + @b
	print @fib
	set @a = @b
	set @b = @fib
end

Download code

Retrieved from "http://literateprograms.org/Fibonacci_numbers_%28T-SQL%29"

Categories: Programming language:Transact-SQL | Fibonacci numbers:Transact-SQL

Fibonacci numbers (T-SQL)

From LiteratePrograms

Implementation

Views

Navigation