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
请问大家在不建立表的情况,怎么可以方便快捷的选择出我要的结果?
解决方案 »
- 求一条SQL 语句
- m_pRecordset如何重新获得记录集(不用老是m_pRecordset->CLOSE,OPEN的)
- sql 字段长度是否影响查询速度
- 创建触发器以后插入数据 提示 "对象名'instered'无效",大虾帮忙看一下
- 如何建立SQL SERVER实例?
- 有人知道ms sql的cast函数把datetime算成binary的具体规则吗?
- и璶开数誹库让远祘ㄏノ蔍数誹库该ń设﹚㎡????
- 在存储过程中怎样执行window命令,如启动NOTEPAD.EXE?
- access2000数据库怎么删除数据后,文件越来越大,怎么让数据删除后数据库会越来越小
- 请问Sqlserver如何将图形操作生成sql ??
- sql批量录入问题,急 在线等~!各位大虾帮帮忙~!
- 求教个数据库应用的简单问题
(
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