哈哈,做出来了。 create table test ( id int primary key, name varchar(16), parentid int ) create trigger tri_test on test for delete as begin if ((select count(*) from deleted) > 0) begin set self_recursion on select * from deleted delete from test where parentid in (select id from deleted) end else set self_recursion off rollback trigger end用delete from test where id = 2就可以了。
create table test
(
id int primary key,
name varchar(16),
parentid int
)
create trigger tri_test on test for delete
as
begin
if ((select count(*) from deleted) > 0)
begin
set self_recursion on
select * from deleted
delete from test where parentid in (select id from deleted)
end
else
set self_recursion off
rollback trigger
end用delete from test where id = 2就可以了。