多条数据同时触发

[Brotter]

一张表QUESTION ID FID
1 0
2 1
3 1
4 1
. .
. .

当我删除ID 1时 ID下的子指标也都删除 如:当我删除1时 2,3,4 都会去删除(我写了一个存储过程实现功能)
;with cte as(
select ID,FID from dbo.Question where ID='1'
union all
select a.ID,a.FIDfrom dbo.Question a inner join cte b on b.ID=a.FID
)
delete from Question where ID in(select Q_ClassCode from cte)

一张表的Appraisalnote 的字段是表QUESTION.ID的值, 例如Appraisalnote 1 2 3 4 ....,
求一触发器 当删除 Question 1时 Appraisalnote表的字段1,2,3,4 都会一起删除!

[JonasFeng]

楼上的正解。

触发器

[Brotter]

csdyyr

看来你没明白我的意思

[feifeiyiwen]

触发器

[ks_reny]

觸發器.

[csdyyr]

--try
create trigger trigger_name on QUESTION 
for delete
as
  ;with cte as(
  select ID,FID from deleted where ID='1'
  union all
  select a.ID,a.FIDfrom dbo.Question a inner join cte b on b.ID=a.FID
  ) 

  delete tb
  from tb join cte on cet.ID=tb.Appraisalnote