select name from syscolumns where object_id('TB1')=id and name in(select name from syscolumns where object_id('TB2')=id)
declare @sql varchar(8000) select @sql=isnull(@sql+',','')+'a.['+a.name+']=b.['+b.name+']' from syscolumns a join syscolumns b on a.name=b.name where a.id=object_id('TB1') and b.id=object_id('TB2') exec ('update a set '+@sql+' from TB1 a join TB2 b on a.主键=b.主键')
select @sql=isnull(@sql+',','')+'a.['+a.name+']=b.['+b.name+']' from syscolumns a join syscolumns b on a.name=b.name where a.id=object_id('TB1') and b.id=object_id('TB2')
exec ('update a set '+@sql+' from TB1 a join TB2 b on a.主键=b.主键')
现在TB1和TB2中no的记录都是5条且完全相同 ,其中TB1中的H,G有记录 TB2的H,G也有记录,但记录不同
我想把TB1中的H和G复制到TB2中no要对应