sql查询不包含的列

 

declare @sql varchar(1000)select @sql='select 'select @sql=@sql+name+',' from syscolumns where id=object_id(N'表a') and name not in ('time')select @sql=left(@sql,len(@sql)-1) select @sql=@sql+' from 表a'exec (@sql)

time为多个字段中不许显示的