使用动态SQL来生成吧 declare @sql varchar(3000) select @sql='' select @sql=@sql+',['+name+']' from syscolumns where id=object_id('tablename') and name not in('field1','field2') select @sql='select '+right(@sql,len(@sql)-1)+' from tablename' exec(@sql)tablename为你要查询的表名,field1,field2为你要排除的两个字段.
declare @sql varchar(3000)
select @sql=''
select @sql=@sql+',['+name+']'
from syscolumns
where id=object_id('tablename')
and name not in('field1','field2')
select @sql='select '+right(@sql,len(@sql)-1)+' from tablename'
exec(@sql)tablename为你要查询的表名,field1,field2为你要排除的两个字段.