SQL批量修改数据

1 1、UPDATE a SET WtNo=b.NO
2 from WT_Task a
3 INNER JOIN WT_BasicInformation b ON a.WtId=b.ID;
4 2、UPDATE a SET a.WtNo=b.NO
5 FROM WT_Task a,WT_BasicInformation b
6 WHERE a.WtId=b.ID;

 

转载于:https://www.cnblogs.com/slmdr9/p/7447878.html