SELECT 1,1,1,1,1,1,1,1,1 FROM (select 1 as a union select 2 union select 3 union select 4 union select 5 union select 6)A where a <= 6 order by a 我现在能写到这种程度,关键是怎么 才能生成一个行的序列呢 ??
这样行不行:declare @i int, @j int, @sql varchar(100) select @i=1, @j=1, @sql='select 'while @i<=3 begin while @j<=5 begin select @sql=@sql+convert(varchar(100),@j)+',' select @j=@j+1 end
select @sql=left(@sql,len(@sql)-1) exec (@sql) select @i=@i+1, @j=1, @sql='select ' end
FROM (select 1 as a union
select 2 union
select 3 union
select 4 union
select 5 union
select 6)A
where a <= 6
order by a 我现在能写到这种程度,关键是怎么 才能生成一个行的序列呢 ??
select @i=1, @j=1, @sql='select 'while @i<=3
begin
while @j<=5
begin
select @sql=@sql+convert(varchar(100),@j)+','
select @j=@j+1
end
select @sql=left(@sql,len(@sql)-1)
exec (@sql)
select @i=@i+1, @j=1, @sql='select '
end