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为多个字段中不许显示的