查询除特定列外的所有列

--查询除_age列的所有其它列

create table test(
_id int,
_name varchar(20), 
_sex varchar(10), 
_age int)

select * from test

declare @SQL varchar(8000)
select @SQL=''select @sql=@SQL+','+[name] from (select [name] from syscolumns where object_id(N'[test]')=[id] and [name]<>'_age') A

set @sql='select '+stuff(@SQL,1,1,'')+' from [test]'
exec (@SQL)

drop table test