62,041
社区成员
发帖
与我相关
我的任务
分享
CREATE trigger gengxin
on gz_xm
for inserted
as
if exists(select info.loginid from login inner join login on info.loginid=login.loginid)
begin
update info
set golden=1000,allasset=1000
from ztxm_mx
join inserted login on info.loginid=login.loginid
end
CREATE trigger gengxin
on gz_xm
for update
as
if exists(select info.loginid from login inner join login on info.loginid=login.loginid)
begin
update info
set golden=1000,allasset=1000
from ztxm_mx
join inserted login on info.loginid=login.loginid
end