create table test(c1 int,c2 int,c3 int,c4 int,c5 int)
insert into test select 1,0,1,0,1
insert into test select 1,1,0,1,0
insert into test select 1,1,0,0,1
insert into test select 0,1,1,0,1
go
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+'+rtrim('+name+')' from syscolumns where id=object_id('test')
set @sql='select '+stuff(@sql,1,1,'')+' from test'
exec(@sql)
select @sql=@sql+'+rtrim('+name+')' from syscolumns where object_id='test'
--〉
select @sql=@sql+'+rtrim('+name+')' from syscolumns where id=object_id('test')
create table test(c1 int,c2 int,c3 int,c4 int,c5 int)
insert into test select 1,0,1,0,1
insert into test select 1,1,0,1,0
insert into test select 1,1,0,0,1
insert into test select 0,1,1,0,1
go
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+'+rtrim('+name+')' from syscolumns where object_id='test'
set @sql='select '+stuff(@sql,1,1,'')+' from test'
exec(@sql)