declare @ varchar(8000)
set @=''
select @=@+rtrim(name)+',' from syscolumns where id=object_id('zryxxb') and name not in ('你不要的列名1','你不要的列名2','你不要的列名3','你不要的列名4')
set @=left(@,len(@)-1)exec('insert jyxxb select '+@+' from zzryxxb where ... ')
set @=''
select @=@+rtrim(name)+',' from syscolumns where id=object_id('zryxxb') and name not in ('你不要的列名1','你不要的列名2','你不要的列名3','你不要的列名4')
set @=left(@,len(@)-1)exec('insert jyxxb select '+@+' from zzryxxb where ... ')
http://expert.csdn.net/Expert/topic/2270/2270480.xml?temp=.9384424
select @s1='insert into zzryxxb('
,@s2=' select 'select @s1=@s1+a.name+',',@s2=@s2+b.name+','
from(
select name from syscolumns where object_id('zzryxxb')=id
) a inner join(
select name from syscolumns where object_id('zzryxxb')=id
) b on a.name=b.nameselect @s1=left(@s1,len(@s1)-1)
,@s2=left(@s2,len(@s2)-1)
exec(@s1+')'+@s2+' from jyxxb')
declare @ varchar(8000)
set @=''
select @=@+rtrim(name)+',' from syscolumns where id=object_id('zryxxb') and name not in ('你不要的列名1','你不要的列名2','你不要的列名3','你不要的列名4')
set @=left(@,len(@)-1)exec('insert jyxxb select '+@+',0,0 from zzryxxb where ... ')对于在zzryxxb表中有,而在jyxxb中不存在的两个字段
先假设是最后两个字段,再假设为数字型