declare @columns varchar(max) set @columns='' select @columns=stuff((select ','+name from syscolumns where id=object_id('test') and name not in('bus_id','price','station_amount') for xml path('')),1,1,'') set @columns='select '+@columns+' from test' exec (@columns)
declare @columns varchar(max)
set @columns=''
select @columns=stuff((select ','+name from syscolumns where id=object_id('test')
and name not in('bus_id','price','station_amount')
for xml path('')),1,1,'')
set @columns='select '+@columns+' from test'
exec (@columns)