创建一个SQL Server 触发器?

发布网友发布时间：2023-09-14 16:42

共2个回答

热心网友时间：2024-07-18 16:36

大体格式,你可以自己修改,重在理解思路!!
Create Trigger tr_CardConsumeDetail
On CardConsumeDetail
for Update ,insert
As
begin
Update CardConsumeDetail
Set currentScore ='要实现的更新'
From CardConsumeDetail c ,Deleted d ,Inserted i --Deleted和Inserted临时表
Where c.id=i.id

update Card
Set score='要实现的更新'
from Card c, Deleted d ,Inserted i
where c.id=i.id
end

热心网友时间：2024-07-18 16:36

create trigger trigger_CardConsumeDetail
on CardConsumeDetail
for insert
as
declare @CONSTRAINT varchar(50)
select @CONSTRAINT =CONSTRAINT from inserted
update CardConsumeDetail set currentScore=新值 where CONSTRAINT =@CONSTRAINT
update Card set score=新值 where where CONSTRAINT =@CONSTRAINT

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com