用动态: declare @sql varchar(4000) select @sql=isnull(@sql,'')+',['+name+']' from syscolumns where id=object_id('表名') and name!='a1' set @sql=left(@sql,len(@sql)-1) exec('select '+@sql+' from 表名')
别的办法~~有是有~~~~但你是为了简便~~~而不是为了解脱问题~~~所以....... 提示: select name from syscolumns where id=object_id('表名')
declare @sql varchar(4000)
select @sql=isnull(@sql,'')+',['+name+']' from syscolumns where id=object_id('表名') and name!='a1'
set @sql=left(@sql,len(@sql)-1)
exec('select '+@sql+' from 表名')
提示:
select name from syscolumns where id=object_id('表名')