Here i will explain how to write a T-SQL to generate the Fibonacci series. I am using CTE (Common Tabular Expression) for this.
SQL:
;WITH Fibonacci (PrevNumber, N) AS
(
SELECT 0, 1
UNION ALL
SELECT N, PrevNumber + N
FROM Fibonacci
WHERE N < 200
)
SELECT PrevNumber as FibonacciSeries
FROM Fibonacci
OPTION (MAXRECURSION 0);