- Posted by ehosca on February 7, 2008
Here's a quick way to generate a sequence of numbers using T-SQL.
WITH NumberGen (number) AS
( SELECT 0
UNION ALL
SELECT number + 1 FROM NumberGen WHERE number < 99)
-- extend as required
SELECT Sequence = first.number * 100 + second.number
FROM NumberGen first, NumberGen second
ORDER BY Sequence
And with LINQ using statements
foreach(int num in Enumerable.Range(0,10000)) // modify to taste
{
Console.WriteLine(num);
}
and using Expressions
from num in Enumerable.Range(0,10000)
select (num)