declare @s varchar(8000)
set @s=''
select @s=@s+',['+name+']' from syscolumns where object_id('要查询的表')=id and colid in(1,3)
set @s=substring(@s,2,8000)
exec('select '+@s+' from 要查询的表')
declare @sql varchar(8000)
set @sql='select '
select @sql=@sql+name+',' from syscolumns where id=object_id('tablename') and colid in (1,3)
set @sql=left(@sql,len(@sql)-1)
exec(@sql+' from tablename ')