22,302
社区成员




update B
set b.ucount = case when a.name IS NULL THEN 1 ELSE 0 END + case when a.age IS NULL THEN 1 ELSE 0 END
from student a
join studentversion b
on a.id = b.studentid
update A
set a.name=ISNULL(a.name, b.name), a.age = ISNULL(a.age, b.age)
from student a
join studentversion b
on a.id = b.studentid
update A
set a.name=ISNULL(a.name, b.name), a.age = ISNULL(a.age, b.age), a.ucount = case when a.name IS NULL THEN 1 ELSE 0 END
+ case when a.age IS NULL THEN 1 ELSE 0 END
from student a
join studentversion b
on a.id = b.studentid