SQL Server 用一张表更新另一张表（表关联更新）_sqlserver根据一个表更新另一个表

通过table2的数据跟table1做关联，将table2列的值更新到table1表中

--第一种方式：通过table2的数据跟table1做关联，将table2列的值更新到table1表中UPDATE table1SET table1.column1 = table2.column1,table1.column2= 1FROM table1,table2 WHERE table1.column2 = table2.column2 AND table1.column3 = table2.column3 AND table1.column4 = \'\' --第二种方式UPDATE FullInspectProductList SET FullInspectProductList.DotRequirements = FullInspectProductList_copy1.DotRequirements,FullInspectProductList.FullInspectMethod = FullInspectProductList_copy1.FullInspectMethod,FullInspectProductList.FullInspectRequirements = FullInspectProductList_copy1.FullInspectRequirements,FullInspectProductList.FullInspectCardUrl = FullInspectProductList_copy1.FullInspectCardUrl,FullInspectProductList.Customer = FullInspectProductList_copy1.Customer,FullInspectProductList.Remarks = FullInspectProductList_copy1.RemarksFROM FullInspectProductList INNER JOIN FullInspectProductList_copy1 ONFullInspectProductList.T_ITEM=FullInspectProductList_copy1.T_ITEM AND FullInspectProductList.FullInspectFactory = FullInspectProductList_copy1.FullInspectFactory