CREATE TRIGGER TRI_DEL ON TB FOR DELETE AS BEGIN DELETE TBB FROM TBB T,DELETED D WHERE T.ID=D.ID END如果只是删除可以用级联,外键关系
create trigger triname on ta for delete as delete tb from deleted d where tb.id=d.id
Create TRIGGER [dbo].[T_trgTable1_Del] ON [dbo].[Table1] for Delete AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; declare @ID int --得到删除的ID select id = @ID from deleted --删除table2表中id= @ID de delete from table2 where id =@ID END
create trigger del on tb for delete as begin delete from tb1 where id in (select id from deleted)end
create trigger tg_del on A for delete as begin delete B where ID=deleted.ID end
create trigger tg_del on A for delete as begin delete B from B,deleted d where B.ID=d.ID end
create trigger tr_del on tb1 for delete as begin delete tb2 from delete d where tb2.id=d.id end
AS
BEGIN
DELETE TBB FROM TBB T,DELETED D WHERE T.ID=D.ID
END如果只是删除可以用级联,外键关系
for delete
as
delete tb from deleted d where tb.id=d.id
Create TRIGGER [dbo].[T_trgTable1_Del]
ON [dbo].[Table1]
for Delete
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @ID int
--得到删除的ID
select id = @ID from deleted
--删除table2表中id= @ID de
delete from table2 where id =@ID
END
for delete
as
begin
delete from tb1
where id in (select id from deleted)end
for delete
as
begin
delete B where ID=deleted.ID
end
for delete
as
begin
delete B from B,deleted d where B.ID=d.ID
end
create trigger tr_del on tb1 for delete
as
begin
delete tb2 from delete d where tb2.id=d.id
end
谢谢了!
inserted表和deleted表用于存放对表中数据行的修改信息。他们是触发器执行时自动创建的,放在内存中,是临时表。当触发器工作完成,它们也被删除。它们是只读表,不能向它们写入内容。
inserted表:用来存储INSERT和UPDATE语句所影响的行的副本。意思就是在inserted表中临时保存了被插入或被更新后的记录行。在执行 INSERT 或UPDATE 语句时,新加行被同时添加到inserted表和触发器表中。因此,可以从inserted表检查插入的数据是否满足需求,如不满足则回滚撤消操(cāo)作。
deleted表:用来存储DELETE和UPDATE语句所影响行的副本。意思是在delete表中临时保存了被删除或被更新前的记录行。在执行 DELETE 或 UPDATE 语句时,行从触发器表中删除,并传到deleted表中。所以可以从deleted表中检查删除的数据行是否能删除。
所以当表中某条记录的某项值发生变化时,变化前的值已经通过系统自动创建的临时表deleted表和inserted表保存了被删除行或插入的记录行的副本。我们可以从这两个表中查询出变化前的值并赋给变量。我给你个表对应一下这两临时表的功能:修改操作 inserted表 deleted表
增加(INSERT)记录时 存放新增的记录 不记录
删除(DELETE)时 不记录 存放被删除的记录
修改(UPDATE)时 存放用来更新的记录 存放更新前的记录
for delete
as
begin
delete from tb1
where id in (select id from deleted)end
一个数据库系统中有两个虚拟表用于存储在表中记录改动的信息,分别是:
虚拟表Inserted 虚拟表Deleted 在表记录新增时 存放新增的记录 不存储记录
修改时 存放用来更新的新记录 存放更新前的记录
删除时 不存储记录 存放被删除的记录
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/fredrickhu/archive/2009/10/21/4708906.aspx具体的看