表h1(i int,j int,k int)
我想写一个触发器,在更新数据后删除插入的那一行,应该怎么写
create trigger tr1
on h1
for insert,update
as
declare @i int,
@j int,
@k int
set @i=(select i from inserted)
set @j=(select j from inserted)
set @k=(select k from inserted)
update h1 set i=i + @i
where j=@j
我想写一个触发器,在更新数据后删除插入的那一行,应该怎么写
create trigger tr1
on h1
for insert,update
as
declare @i int,
@j int,
@k int
set @i=(select i from inserted)
set @j=(select j from inserted)
set @k=(select k from inserted)
update h1 set i=i + @i
where j=@j
on h1
instead of insert,update
as
/*
declare @i int,
@j int,
@k int
set @i=(select i from inserted)
set @j=(select j from inserted)
set @k=(select k from inserted)
update h1 set i=i + @i
where j=@j
*/update a set a.i=a.i+b.i from h1 a join INSERTED b on a.j=b.j
insert into h1 select * from INSERTED t where not exists (select 1 from h1 where j=t.j)