sqlsever 表有100个字段，查询前43个。

Question

sqlsever 表有100个字段，查询前43个。select 语句该怎么写？
不要说select后面把那43个字段都列出来。

Answer 1

select top 43 IDENTITY(int,1,1)AID,name into #t from syscolumnswhere id=(select id from sysobjects where name='表名') order by coliddeclare @AID int,@Sel varchar(1000)select @AID=1,@Sel=''while @AID<=43beginselect @Sel=case when @Sel='' then name else @Sel+','+name end from #t Where AID=@AIDset @AID=@AID+1endexec('select '+ @Sel + ' From 表名')