【025】远程更新扩展字段示例

exec sp_addlinkedserver
@server='remoteDB', --链接服务器别名
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='139.9.102.220' --要访问的的数据库所在的服务器的ip
GO
EXEC sp_addlinkedsrvlogin
'remoteDB', --链接服务器别名
'false',
NULL,
'sa', --要访问的数据库的用户
'dwjj!@$2017' --要访问的数据库，用户的密码
GO
--以后不再使用时删除链接服务器 
-- exec sp_dropserver 'remoteDB','droplogins' 

update Cust_RtnProfitOrder set 
   DescFlexField_PrivateDescSeg1 = B.DescFlexField_PrivateDescSeg1 
  ,DescFlexField_PrivateDescSeg2 = B.DescFlexField_PrivateDescSeg2 
  ,DescFlexField_PrivateDescSeg3 = B.DescFlexField_PrivateDescSeg3 
  ,DescFlexField_PrivateDescSeg4 = B.DescFlexField_PrivateDescSeg4 
  ,DescFlexField_PrivateDescSeg5 = B.DescFlexField_PrivateDescSeg5 
  ,DescFlexField_PrivateDescSeg6 = B.DescFlexField_PrivateDescSeg6 
  ,DescFlexField_PrivateDescSeg7 = B.DescFlexField_PrivateDescSeg7 
  ,DescFlexField_PrivateDescSeg8 = B.DescFlexField_PrivateDescSeg8 
  ,DescFlexField_PrivateDescSeg9 = B.DescFlexField_PrivateDescSeg9 
  ,DescFlexField_PrivateDescSeg10= B.DescFlexField_PrivateDescSeg10
  ,DescFlexField_PrivateDescSeg11= B.DescFlexField_PrivateDescSeg11
  ,DescFlexField_PrivateDescSeg12= B.DescFlexField_PrivateDescSeg12
  ,DescFlexField_PrivateDescSeg13= B.DescFlexField_PrivateDescSeg13
  ,DescFlexField_PrivateDescSeg14= B.DescFlexField_PrivateDescSeg14
  ,DescFlexField_PrivateDescSeg15= B.DescFlexField_PrivateDescSeg15
  ,DescFlexField_PrivateDescSeg16= B.DescFlexField_PrivateDescSeg16
  ,DescFlexField_PrivateDescSeg17= B.DescFlexField_PrivateDescSeg17
  ,DescFlexField_PrivateDescSeg18= B.DescFlexField_PrivateDescSeg18
  ,DescFlexField_PrivateDescSeg19= B.DescFlexField_PrivateDescSeg19
  ,DescFlexField_PrivateDescSeg20= B.DescFlexField_PrivateDescSeg20
  ,DescFlexField_PrivateDescSeg21= B.DescFlexField_PrivateDescSeg21
  ,DescFlexField_PrivateDescSeg22= B.DescFlexField_PrivateDescSeg22
  ,DescFlexField_PrivateDescSeg23= B.DescFlexField_PrivateDescSeg23
  ,DescFlexField_PrivateDescSeg24= B.DescFlexField_PrivateDescSeg24
  ,DescFlexField_PrivateDescSeg25= B.DescFlexField_PrivateDescSeg25
  ,DescFlexField_PrivateDescSeg26= B.DescFlexField_PrivateDescSeg26
  ,DescFlexField_PrivateDescSeg27= B.DescFlexField_PrivateDescSeg27
  ,DescFlexField_PrivateDescSeg28= B.DescFlexField_PrivateDescSeg28
  ,DescFlexField_PrivateDescSeg29= B.DescFlexField_PrivateDescSeg29
  ,DescFlexField_PrivateDescSeg30= B.DescFlexField_PrivateDescSeg30
  ,DescFlexField_PubDescSeg1= B.DescFlexField_PubDescSeg1
  ,DescFlexField_PubDescSeg2 = B.DescFlexField_PubDescSeg2 
  ,DescFlexField_PubDescSeg3 = B.DescFlexField_PubDescSeg3 
  ,DescFlexField_PubDescSeg4 = B.DescFlexField_PubDescSeg4 
  ,DescFlexField_PubDescSeg5 = B.DescFlexField_PubDescSeg5 
  ,DescFlexField_PubDescSeg6 = B.DescFlexField_PubDescSeg6 
  ,DescFlexField_PubDescSeg7 = B.DescFlexField_PubDescSeg7 
  ,DescFlexField_PubDescSeg8 = B.DescFlexField_PubDescSeg8 
  ,DescFlexField_PubDescSeg9 = B.DescFlexField_PubDescSeg9 
  ,DescFlexField_PubDescSeg10= B.DescFlexField_PubDescSeg10
  ,DescFlexField_PubDescSeg11= B.DescFlexField_PubDescSeg11
  ,DescFlexField_PubDescSeg12= B.DescFlexField_PubDescSeg12
  ,DescFlexField_PubDescSeg13= B.DescFlexField_PubDescSeg13
  ,DescFlexField_PubDescSeg14= B.DescFlexField_PubDescSeg14
  ,DescFlexField_PubDescSeg15= B.DescFlexField_PubDescSeg15
  ,DescFlexField_PubDescSeg16= B.DescFlexField_PubDescSeg16
  ,DescFlexField_PubDescSeg17= B.DescFlexField_PubDescSeg17
  ,DescFlexField_PubDescSeg18= B.DescFlexField_PubDescSeg18
  ,DescFlexField_PubDescSeg19= B.DescFlexField_PubDescSeg19
  ,DescFlexField_PubDescSeg20= B.DescFlexField_PubDescSeg20
  ,DescFlexField_PubDescSeg21= B.DescFlexField_PubDescSeg21
  ,DescFlexField_PubDescSeg22= B.DescFlexField_PubDescSeg22
  ,DescFlexField_PubDescSeg23= B.DescFlexField_PubDescSeg23
  ,DescFlexField_PubDescSeg24= B.DescFlexField_PubDescSeg24
  ,DescFlexField_PubDescSeg25= B.DescFlexField_PubDescSeg25
  ,DescFlexField_PubDescSeg26= B.DescFlexField_PubDescSeg26
  ,DescFlexField_PubDescSeg27= B.DescFlexField_PubDescSeg27
  ,DescFlexField_PubDescSeg28= B.DescFlexField_PubDescSeg28
  ,DescFlexField_PubDescSeg29= B.DescFlexField_PubDescSeg29
  ,DescFlexField_PubDescSeg30= B.DescFlexField_PubDescSeg30
  ,DescFlexField_PubDescSeg31= B.DescFlexField_PubDescSeg31
  ,DescFlexField_PubDescSeg32= B.DescFlexField_PubDescSeg32
  ,DescFlexField_PubDescSeg33= B.DescFlexField_PubDescSeg33
  ,DescFlexField_PubDescSeg34= B.DescFlexField_PubDescSeg34
  ,DescFlexField_PubDescSeg35= B.DescFlexField_PubDescSeg35
  ,DescFlexField_PubDescSeg36= B.DescFlexField_PubDescSeg36
  ,DescFlexField_PubDescSeg37= B.DescFlexField_PubDescSeg37
  ,DescFlexField_PubDescSeg38= B.DescFlexField_PubDescSeg38
  ,DescFlexField_PubDescSeg39= B.DescFlexField_PubDescSeg39
  ,DescFlexField_PubDescSeg40= B.DescFlexField_PubDescSeg40
  ,DescFlexField_PubDescSeg41= B.DescFlexField_PubDescSeg41
  ,DescFlexField_PubDescSeg42= B.DescFlexField_PubDescSeg42
  ,DescFlexField_PubDescSeg43= B.DescFlexField_PubDescSeg43
  ,DescFlexField_PubDescSeg44= B.DescFlexField_PubDescSeg44
  ,DescFlexField_PubDescSeg45= B.DescFlexField_PubDescSeg45
  ,DescFlexField_PubDescSeg46= B.DescFlexField_PubDescSeg46
  ,DescFlexField_PubDescSeg47= B.DescFlexField_PubDescSeg47
  ,DescFlexField_PubDescSeg48= B.DescFlexField_PubDescSeg48
  ,DescFlexField_PubDescSeg49= B.DescFlexField_PubDescSeg49
  ,DescFlexField_PubDescSeg50= B.DescFlexField_PubDescSeg50
from Cust_RtnProfitOrder A,remoteDB.[T20211231].[dbo].[Cust_RtnProfitOrder] B
where A.ID=B.ID

-- 多语言表
update Cust_RtnProfitOrder_Trl set DescFlexField_CombineName=B.DescFlexField_CombineName
from Cust_RtnProfitOrder_Trl A,remoteDB.[T20211231].[dbo].[Cust_RtnProfitOrder_Trl] B
where A.ID=B.ID