sql server多表数据批量更新

update w
set w.TagCount=x.TagCount
from (select ItemID,COUNT(*) as TagCount from r where IsValid=1 group by ItemID) as x
where ID =4 and IsValid=1 and w.ID=x.ItemID

sql server多表数据批量更新,布布扣,bubuko.com

原文：http://www.cnblogs.com/xiaofoyuan/p/3571358.html