批量更改两个关联表的SQL脚本:
脚本1:
UPDATE a SET WtNo=b.NOfrom WT_Task aINNER JOIN WT_BasicInformation b ON a.WtId=b.ID;
脚本2:
UPDATE a SET a.WtNo=b.NOFROM WT_Task a,WT_BasicInformation bWHERE a.WtId=b.ID;
实战用到:
UPDATE t1 SET starttime=t2.StartTime ,endtime=t2.Endtime FROM RBCNEW.dbo.O_TimeSlot t1,RBCNEW_DEV.dbo.O_TimeSlot t2 WHERE t1.id=t2.id