替换掉表中旧的projectid值
declare @a table(
old nvarchar(20),
new nvarchar(20)
)
insert into @a values('1000066175','1000071422')
insert into @a values('1000068732','1000071995')
update dbo.FORECAST
set PROJECT_ID = b.new
from FORECAST inner join @a b on FORECAST.Project_Id = b.old