UPDATE dbo.Table2 SET dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB FROM dbo.Table2 INNER JOIN dbo.Table1 ON Table2.ColA = Table1.ColA
declare @發票號碼 varchar(16) set @發票號碼='ZB56491199' update 統一發票單身 set 統一發票單身.順序=a.新順序 from (select 100+row_number() over (order by 原始順序 asc) as 新順序, 順序 from 統一發票單身 where 發票號碼=@發票號碼) as a where 統一發票單身.發票號碼=@發票號碼 and 統一發票單身.順序=a.順序 update 統一發票單身 set 順序=順序-100 where 發票號碼=@發票號碼