select top 43 IDENTITY(int,1,1)AID,name into #t from syscolumns

where id=(select id from sysobjects where name='表名') order by colid
declare @AID int,@Sel varchar(1000)
select @AID=1,@Sel=''
while @AID<=43
begin
select @Sel=case when @Sel='' then name else @Sel+','+name end from #t Where AID=@AID
set @AID=@AID+1
end
exec('select '+ @Sel + ' From 表名')