本文介绍了一段用于更新用户计数的SQL脚本，该脚本通过连接两个表来计算特定日期内公司的数量，并将结果更新到用户计数表中。此脚本适用于需要跟踪公司注册情况的应用场景。
update tb_UserCount
set i_CNum=(
select COUNT(i_Id)
from tb_Company
where datediff(DAY, tb_UserCount.dt_DateTime, tb_Company.dt_DateTime )=0
and tb_Company.i_uid=tb_UserCount.i_Uid )
where exists(select * from tb_Company where datediff(DAY, tb_UserCount.dt_DateTime, tb_Company.dt_DateTime )=0
and tb_Company.i_uid=tb_UserCount.i_Uid)
set i_CNum=(
select COUNT(i_Id)
from tb_Company
where datediff(DAY, tb_UserCount.dt_DateTime, tb_Company.dt_DateTime )=0
and tb_Company.i_uid=tb_UserCount.i_Uid )
where exists(select * from tb_Company where datediff(DAY, tb_UserCount.dt_DateTime, tb_Company.dt_DateTime )=0
and tb_Company.i_uid=tb_UserCount.i_Uid)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
