SQL 小ネタ

数列の作成方法

---

数列を作る方法

DECLARE @Count   INT = 100;

WITH NumberTable (SeqNo)
AS
(
     SELECT 1
     UNION ALL
     SELECT 1 + SeqNo
     FROM   NumberTable
     WHERE  SeqNo < @Count
)
SELECT  SeqNo
FROM    NumberTable
OPTION (MAXRECURSION 0);