如何做一个删除主从表的触发器

[runquickly]

我有两张表,它们之间是一对多的关系,我想在删除主表记录是,通过触发器把从表记录也删除
我做的如下,可是不能通过语法测试,请高手指点.
create trigger xxx on 我的主表 for delete
AS
declare 编号 char(10)
set @bh=deleted.编号
delete from 我的从表 where 我的从表.编号=@bh
go

[txlicenhe]

create trigger xxx on 我的主表 for delete
AS

delete a from 我的从表 a
where exists(select 1 from deleted where 编号 = a.编号)

[davorsuker39]

create trigger xxx on 我的主表 for delete
AS

delete a from 我的从表 a
where exists(select 1 from deleted where 编号 = a.编号)