随笔

--update [dbo].[EmployeeSalaryDetailTable]
--set SalePeriod_Id=(select SalePeriod_Id from dbo.Base_SalePeriod where SalePeriod_Name=[EmployeeSalaryDetailTable].SalePeriod_Name)

update [tianzow2_new2].[dbo].[EmployeeSalaryDetailTable]
set [SalePeriod_Id]=[tianzow2_new2].[dbo].[Base_SalePeriod].[SalePeriod_Id]
from [tianzow2_new2].[dbo].[Base_SalePeriod]
where [tianzow2_new2].[dbo].[EmployeeSalaryDetailTable].[SalePeriod_Name]=[tianzow2_new2].[dbo].[Base_SalePeriod].[SalePeriodName]

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/Ly426/p/9486090.html