随笔
2018-08-16 11:05 马尔代夫_珍 阅读(177) 评论(0) 编辑 收藏 举报 --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]