declare @sql nvarchar(1024)
set @sql=''
select @sql=@sql+'a.'+syscolumns.name+'=b.'+syscolumns.name+',' from
syscolumns inner join sysobjects
on syscolumns.id=sysobjects.id
where sysobjects.name='a'
set @sql=substring(@sql,1,len(@sql)-1)
set @sql='update a set '+@sql+' from a inner join b on a.a=b.a'
select @sql=@sql+'a.'+syscolumns.name+'=b.'+syscolumns.name+',' from
syscolumns inner join sysobjects
on syscolumns.id=sysobjects.id
where sysobjects.name='a'
set @sql=substring(@sql,1,len(@sql)-1)
set @sql='update a set '+@sql+' from a inner join b on a.a=b.a'
select @sql=@sql+'a.'+syscolumns.name+'=b.'+syscolumns.name+',' from
syscolumns inner join sysobjects
on syscolumns.id=sysobjects.id
where sysobjects.name='AconxNews'
set @sql=substring(@sql,1,len(@sql)-1)
set @sql='update a set '+@sql+' from a inner join b on a.a=b.a'