34,587
社区成员
发帖
与我相关
我的任务
分享
declare @id int
set @id=1
if exists (select 1 from B where id=@id)
begin
update B set B.data=B.data+A.data
from B
inner join A
on A.id=B.id and A.id=@id
end
else
begin
insert into B
select * from A where id=@id
end