--如果嫌手输麻烦或输错,把要的字段名 print 出来,复制粘贴declare @Cols varchar(1000)select @Cols = isnull(@Cols+',','') + name from syscolumns where id=object_id('表名') and name not in ('不要的字段1',..,'不要的字段n') order by colorderprint @Cols
declare @sql varchar(200) select @sql=isnull(@sql+',','')+name from syscolumns where id=object_id('表名') and name<>'A' exec('select '+@sql+' from 表名')
from syscolumns
where id=object_id('表名') and name not in ('不要的字段1',..,'不要的字段n')
order by colorderprint @Cols
declare @sql varchar(200)
select @sql=isnull(@sql+',','')+name from syscolumns where id=object_id('表名') and name<>'A'
exec('select '+@sql+' from 表名')