select 多个列明，请高手帮忙

Question

declare @count int 
set @count = 1 
while @count <11 
begin 
exec('select ggg_'+ltrim(@count)+' from test') 
end 
go

Answer 1

declare @count int 
declare @Str varchar(20)set @count = 1 
while @count <8 
begin 
set @Str = 'select  ggg_' +ltrim(@count)
exec(@Str+' from test')
set @count=@count+1end @count要自加,还有就是不能到11,你表里就只有到8,查询出来ggg_9...时会出现问题

Answer 2

create table test( 
ggg_1 varchar(100), 
ggg_2 varchar(100), 
ggg_3 varchar(100), 
ggg_4 varchar(100), 
ggg_5 varchar(100), 
ggg_6 varchar(100), 
ggg_7 varchar(100), 
ggg_8 varchar(100) 
) 
declare @count as int 
declare @sql as varchar(1000) 
set @sql = 'select '
set @count = 1 
while @count <= 8 
begin
  set @sql = @sql + 'ggg_' + cast(@count as varchar) + ',' 
  set @count = @count + 1
end set @sql = left(@sql , len(@sql) - 1) + ' from test'
exec(@sql)drop table test/*
ggg_1                                                                                                ggg_2                                                                                                ggg_3                                                                                                ggg_4                                                                                                ggg_5                                                                                                ggg_6                                                                                                ggg_7                                                                                                ggg_8                                                                                                
---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- */