Ⅰ SQL Server有表A,表B，查詢後立馬更新數據 求大神幫忙
先按照公式，把a表中的數值計算出來，然後關聯更新數據。
UPDATE B
SET B.aa = x.counts ,
B.bb = (case when x.counts >=10 and x.counts<20 then 4
when x.counts>=20 then 5
else null end )
FROM B
JOIN
(SELECT a.id,
SUM(CASE
WHEN a.aa IN (0, 1) THEN
2
WHEN a.aa IS NULL THEN
4
END) counts
FROM A GROUP BY id) x ON b.id = x.id
Ⅱ SQL 更新的同時做查詢
那就關繫到「鎖」的問題了吧