SqlServer根据一个表更新另一个表数据
2023-09-27 15:12 NO.27 阅读(209) 评论(0) 收藏 举报--根据B更新A
UPDATE a SET a.RecordId=b.RecordId FROM dbo.Z_InternalContract_RecordAttachment a JOIN dbo.T_InternalContract_Record b ON a.Old_RecordId=b.Old_RecordId
--根据B更新A
UPDATE a SET a.RecordId=b.RecordId FROM dbo.Z_InternalContract_RecordAttachment a JOIN dbo.T_InternalContract_Record b ON a.Old_RecordId=b.Old_RecordId
浙公网安备 33010602011771号