SQLServer批量更新两个关联表数据的方法

UPDATE a SET WtNo=b.NOfrom WT_Task aINNER JOIN WT_BasicInformation b ON a.WtId=b.ID;

UPDATE a SET a.WtNo=b.NOFROM WT_Task a,WT_BasicInformation bWHERE a.WtId=b.ID;