批量更新冗余表中不一致的数据。

update a set a.BName = b.Name from 表1 as a,表2 as b
where a.BRowGuid = b.RowGuid and a.BName <> b.Name