Update customer set a.tel_1=b.tel_1,a.tel_2=b.tel_2,a.mobile=b.mobile from customer a,MyStudy_Test.dbo.customer b Where a.customer_guid=b.customer_guid and a.tel_1<>b.tel_1 and a.tel_2<>b.tel_2 and a.mobile<>b.mobile如果tel_1,tel_2,mobile其中有位空的呢? 这样很有可能更新会有问题吧?
and a.tel_1<>b.tel_1 and a.tel_2<>b.tel_2 and a.mobile<>b.mobile如果tel_1,tel_2,mobile其中有位空的呢? 这样很有可能更新会有问题吧?