--UPDATE FROM
UPDATE BasDeptInfo SET ManagerNo=table2.newno
FROM BasDeptInfo,table2
WHERE ManagerNo=table2.oldno
SqlServer UPDATE FROM
最新推荐文章于 2024-03-01 13:21:37 发布
--UPDATE FROM
UPDATE BasDeptInfo SET ManagerNo=table2.newno
FROM BasDeptInfo,table2
WHERE ManagerNo=table2.oldno