110,533
社区成员
发帖
与我相关
我的任务
分享
exec sp_addlinkedserver 'srv_lnk4','','SQLOLEDB','192.168.101.4'
exec sp_addlinkedsrvlogin 'srv_lnk4','false',null,'sa','1234qwer'
update A
set A.MainDiagnose = B.MainDiagnose
,A.OutSectionInfoCode = B.OutSectionInfoCode
from srv_lnk4.DB_HIS_INFO.dbo.v_PatientDiagInfo B
inner join Hospital.dbo.Diagnose A
ON B.HospitalID = A.HospitalID
where A.MainDiagnose is null
exec sp_dropserver 'srv_lnk4','droplogins'