select 1
union
select 2
union
select 3
union
select 4
union
select 5
......
union
select 9999
请问大家在不建立表的情况,怎么可以方便快捷的选择出我要的结果?
union
select 2
union
select 3
union
select 4
union
select 5
......
union
select 9999
请问大家在不建立表的情况,怎么可以方便快捷的选择出我要的结果?
(
select 0 as a
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as a,(
select 0 as b
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as b,(
select 0 as a
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as c,(
select 0 as a
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as d
declare @i intset @i = 1while @i < 10000
begin
insert @table
select @i set @i = @i + 1
endselect * from @table
from (
select 0 as a
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as a,(
select 0 as b
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as b,(
select 0 as c
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as c,(
select 0 as d
union
select 1
union
select 2
union
select 3
union
select 4
union
select 5
union
select 6
union
select 7
union
select 8
union
select 9
) as d
order by a+10*b+100*c+1000*d+1