create trigger tr_test on type
for delete
as
begin
delete from title a,deleted b where a.type_id=b.type_id
end
for delete
as
begin
delete from title a,deleted b where a.type_id=b.type_id
end
解决方案 »
- 一句sql不知道怎么写
- 从安全性和稳定性考虑,SQL SERVER 2005 SP3 是安装在WIN2003,WIN7,还是WIN 2008下好.
- 请高手进:一个不好写SQL语句的查询,50
- 请问各位大侠,为什么VB.NET 2003不能运行VB.NET 2002的程序出错呢?
- 关于MS Server的备份
- ODBC 驱动程序不支持所需的属性。
- 关于sql join查询。。这个语句到底怎么查?
- : 我想把Table的一个字段的属性定义为另一个Table(表结构不同)的内容,大家给点指导好吗?
- SQLServer为什么要将编译器和执行器完全分成两部份?
- sql存储过程语法问题
- 事務處理,可以保證完全安全麼?假如遇到下面的情況會不 會,出現錯誤??
- 表能否定義為輸出參數?
for delete
as
declare @id int
select @id=id from deleted
delete from title where type_id=@id
go
for delete as
delete title where title.id in (select id from deleted)
go
create trigger tr_test on type
for delete
as
begin
delete from title where type_id in (select id from deleted)
end
for delete
as
declare @id int
select @id=id from deleted
delete from title where type_id=@id说明在产生触发器的同时会产生两个临时的表deleted 和inserted 他们的样式和你表的样式一模一样,一个用来存放你要删除的数据,一个用来存放你要插入的数据