--from zjcxc(邹建) @csdn
--经过修改
--使用动态的SQL语句
declare @s nvarchar(4000)
declare @sql nvarchar(4000)
set @s=''
select @s=case a.name when 'id' then @s else @s+',['+a.name+']'end
from mytmp01.dbo.syscolumns a,mytmp02.dbo.syscolumns b
where a.name=b.name
and a.id=object_id('mytmp01.dbo.tbl_tmp1')
and b.id=object_id('mytmp02.dbo.tbl_tmp1')
set @s=stuff(@s,1,1,'')
set @sql='
insert into mytmp02.dbo.tbl_tmp1('+ @s +')
select '+ @s +'
from mytmp01.dbo.tbl_tmp1
where id=-1
'
select @sql
--exec(@sql)