数列の作成方法
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);