一条SQL语句,生成整数序列
如下:
num
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
......
999
1000
------解决思路----------------------
with t
as
(
select 1 as dt union all
select dt+1 from t where dt+1<=1000
)
select dt from t option(maxrecursion 0)
------解决思路----------------------
select number
from master..spt_values v
where v.type='p'and v.number between 1 and 1000