select name,id into #t1 from sysobjects where parent_obj=0 and id >100 and xtype='U'
select name,id,colid from syscolumns where id in (select id from #t1) and id=1435079declare @s varchar(8000)
set @s=''
select @s=@s+','+name from syscolumns where id in (select id from #t1) and id=1435079
set @s=stuff(@s,1,1,'')--这是你要的值exec('insert into table1 ('+@s+')
select '+@s+' from table2')
select name,id,colid from syscolumns where id in (select id from #t1) and id=1435079declare @s varchar(8000)
set @s=''
select @s=@s+','+name from syscolumns where id in (select id from #t1) and id=1435079
set @s=stuff(@s,1,1,'')--这是你要的值exec('insert into table1 ('+@s+')
select '+@s+' from table2')
insert into table1 (chatid,roomid,username)
select name,id,colid from syscolumns where id in
(select id from sysobjects where parent_obj=0 and id >100 and xtype='U' )
and id=1435079
Select @S=''
Select @S=@S+','+name from syscolumns where id=1435079 Order By ColID
Select @S=Stuff(@S,1,1,'')
EXEC('insert into table1 ('+@s+') select '+@s+' from table2')