--delete触发器
create trigger test on A for delete
as
delete B from B inner join deleted d on b.p1=d.p1 and b.p2=d.p2 and b.p3=d.p3--update触发器
create trigger test1 on A for update
as
update B set p4=i.p4 from B inner join inserted i on b.p1=i.p1 and b.p2=i.p2 and b.p3=i.p3
create trigger test on A for delete
as
delete B from B inner join deleted d on b.p1=d.p1 and b.p2=d.p2 and b.p3=d.p3--update触发器
create trigger test1 on A for update
as
update B set p4=i.p4 from B inner join inserted i on b.p1=i.p1 and b.p2=i.p2 and b.p3=i.p3
解决方案 »
- 帮忙写个sql!!!!
- 如果一个物理服务器上有多个SqlServer实例,那么为了确保客户端能访问到正确的实例,SqlServer2005提供了什么服务来解决这个问题?
- 如何在存储过程中输出 “select top 1 基本信息编号 from 基本信息 order by 基本信息编号 desc”结果??
- 有用VSS管理SSIS项目的吗?
- 请问为什么不是最后一行对应的那一列的值
- 数据库统计的的问题!!在先等!
- 求助!
- 回YOUYU6:程序已经运行一年多了,客户重装MS SQL2000服务器后有严重阻塞和死锁的情况,请高手指点下?
- 请问大家。。。
- SQL连接问题
- 存储过程中的表名处理
- 请问如何将数组中的每一个元素插入到数据库中?
on a
for update
as
begin
update b set b.p1=tmp.p1,b.p2=tmp.p2,b.p1=tmp.p2
from( select * from inserted ) as tmp
end
on a
for
delete
begin
delete from b where b.p1 in (select p1 from deleted) and
b.p2 in (select p2 from deleted) and p3 in (select p3 from deleted) end
B(p1,p2,p3,......)
p1,p2,p3 为A表主键1,当A表的p1,p2,p3更新(主键更新),B表(p1,p2,p3)相应更新
2,当A表删除记录,B表相应记录删除做成一个触发器
这个触发器该怎么写?
请指点!