Insert Or Update

inup.sql

DECLARE @UpdateTable table(--暫存表，用以暫時儲存要更新或新增的目標資料
	[Id] int,
	[Name] nvarchar(16),
	[Count] int
)
insert @UpdateTable select Min([Id]),Min([Name]),Sum([Count]) from (--將要更新的資料寫入暫存表
	select * from [test].[TableA]
	union all
	select * from [test].[TableB]
) as TempA group by [Id]

while(exists(select * from @UpdateTable))BEGIN--將更新表中的資料逐筆讀出
	DECLARE @Id int,@Count int;
	select top 1 @Id = [Id],@Count = [Count] from @UpdateTable;--讀出資料
	if(exists(select * from [test].[TableB] where [Id] = @Id))
		update [test].[TableB] set [Count] = @Count where [Id] = @Id;--更新TableB
	else
		insert [test].[TableB] select top 1 * from @UpdateTable--插入一筆新資料
	delete @UpdateTable where [Id] = @Id;--已經更新過的資料刪除
end