34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #A(id INT, coin INT)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(1,10)
CREATE TABLE #B(id INT, coin INT)
INSERT INTO #B VALUES(1,2)
INSERT INTO #B VALUES(2,2)
INSERT INTO #B VALUES(3,2)
INSERT INTO #B VALUES(3,2)
INSERT INTO #B VALUES(1,2)
INSERT INTO #B VALUES(1,2)
update #A set coin=coin+isnull((select sum(coin) from #B where id=a.id),0) from #A as a
update a
set coin=a.coin+b.coin
from #a a,(
select id,sum(coin) as coin
from #b
group by id
) as b
where a.id=b.id
select id,sum(coin) coin
(select * from #a
unoin
select * from #b )
group by id
insert into #a select * from #b where
INSERT INTO #A VALUES(1,10)
INSERT INTO #A VALUES(2,10)
INSERT INTO #A VALUES(3,10)
INSERT INTO #A VALUES(4,10)
INSERT INTO #A VALUES(5,10)
INSERT INTO #A VALUES(6,10)
INSERT INTO #A VALUES(7,10)
insert into #b(id,coin) select id,coin from #a