--表A
create table A
(id int , name varchar60, score int)
go
insert into A values(1,'张三',80)
insert into A values(2,'李四',70)
insert into A values(3,'AA',50)
insert into A values(4,'CC,40)
select * from A
go 我想创建一个存储器 在每次操作表A的时候(insert,update,delete)的时候,如果score>60,就在表B中记录当前操作的ID,score但是如果是多次操作同一条记录 就更新表B中该条记录的score
create table A
(id int , name varchar60, score int)
go
insert into A values(1,'张三',80)
insert into A values(2,'李四',70)
insert into A values(3,'AA',50)
insert into A values(4,'CC,40)
select * from A
go 我想创建一个存储器 在每次操作表A的时候(insert,update,delete)的时候,如果score>60,就在表B中记录当前操作的ID,score但是如果是多次操作同一条记录 就更新表B中该条记录的score
create trigger my_trig on A for insert ,update ,delete
as
if not exists(select 1 from inserted where score > 60)
......
else if not exists(select 1 from deleted where score > 60)
......
else
......
go
as
if not exists(select 1 from inserted where score > 60)
......
else if not exists(select 1 from deleted where score > 60)
......
else
......
go
这个
if not exists(select 1 from inserted where score > 60)
......
else if not exists(select 1 from deleted where score > 60)
......
else
......怎么理解啊 不太懂