怎么把A数据库中A表的数据同步更新到B数据中的B表上？

w345135861 2019-05-13 10:43:36

insert into AIS20190505150649.dbo.HR_ATS_Holiday(FEmpID,FBillID,FHolidayTypeID,FSheetNo,FLeaveDate,FStartTime,FEndTime,FLeaveLength,FIsFullDay,FUnit,FLeaveReason,FIsContinue,FContinueTime,FSubmitDate,FStatus,FIsAgree,FAgreeUser,FCheckUser,FCheckTime,FRemark,FOperator,FOperatorIP,FOperateTime,FOperatorHost,FIsHarfDay,FSplit,FTotalLength,

FSubBillID,FRefLength,FCreatDate )

select FEmpID,FBillID,FHolidayTypeID,FSheetNo,FLeaveDate,FStartTime,FEndTime,FLeaveLength,FIsFullDay,FUnit,FLeaveReason,

FIsContinue,FContinueTime,FSubmitDate,FStatus,FIsAgree,FAgreeUser,FCheckUser,FCheckTime,FRemark,FOperator,FOperatorIP,FOperateTime,FOperatorHost,FIsHarfDay,FSplit,FTotalLength,

FSubBillID,FRefLength,FCreatDate  from HR201410.dbo.HR_ATS_Holiday

WHERE FSubBillID NOT IN (SELECT FSubBillID FROM AIS20190505150649.dbo.HR_ATS_Holiday )

我用这段语句把数据是同步过去了，但是A数据库中的FStatus字段值更新时，B数据中的FStatus不更新，请老师们指导一下，谢谢！

...全文

535 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

shildkix 2019-05-14

打赏
举报

not in 效率较差改成join比较好
insert into AIS20190505150649.dbo.HR_ATS_Holiday(FEmpID,FBillID,FHolidayTypeID,FSheetNo,FLeaveDate,FStartTime,FEndTime,FLeaveLength,FIsFullDay,FUnit,FLeaveReason,FIsContinue,FContinueTime,FSubmitDate,FStatus,FIsAgree,FAgreeUser,FCheckUser,FCheckTime,FRemark,FOperator,FOperatorIP,FOperateTime,FOperatorHost,FIsHarfDay,FSplit,FTotalLength,
FSubBillID,FRefLength,FCreatDate )
select FEmpID,FBillID,FHolidayTypeID,FSheetNo,FLeaveDate,FStartTime,FEndTime,FLeaveLength,FIsFullDay,FUnit,FLeaveReason,
FIsContinue,FContinueTime,FSubmitDate,FStatus,FIsAgree,FAgreeUser,FCheckUser,FCheckTime,FRemark,FOperator,FOperatorIP,FOperateTime,FOperatorHost,FIsHarfDay,FSplit,FTotalLength,
FSubBillID,FRefLength,FCreatDate from HR201410.dbo.HR_ATS_Holiday a LEFT JOIN(SELECT FSubBillID from AIS20190505150649.dbo.HR_ATS_Holiday) b ON a.FSubBillID=b.FSubBillID
WHERE b.FSubBillID IS null