34,593
社区成员
发帖
与我相关
我的任务
分享
if Update(LastLoginDate)
BEGIN
insert User_fen(UserId,fen,adddate,fentype)
select UserId,5,LastLoginDate,1 from inserted
where not exists
(select 1 from User_fen where adddate >=CONVERT(date,getdate())
END