请大家帮忙呀一调试通过就给100分触发器的问题!

Question

在删除SGQYB里的ZZZBH的一条记录的时同时删除TBBSB里对应的字段ZZZBH对应的一条记录  

Answer 1

Create trigger yourTriggerName on SGQYB
For Delete
As
   Delete TBBSB where zzzbh in (Select zzzbh from deleted)

Answer 2

creat trigger T_deltable on sgqyb 
 as
  delete table tbbsb where zzzbh=deleted.zzzbh
go

Answer 3

creat trigger T_deltable on sgqyb for delete
 as
  delete table tbbsb where zzzbh=deleted.zzzbh
go

Answer 4

create Trigger T_Del ON SGQYB 
FOR DELETE
AS
BEGIN
 Delete FROM TBBSB where zzzbh in (Select zzzbh from deleted)        IF @@ERROR <>0
        BEGIN
RAISERROR ('删除失败！', 16, 1)
ROLLBACK TRAN
RETURN
        END
END

Answer 5

Create trigger yourTriggerName on SGQYB
For Delete
As
   Delete TBBSB from deleted  where zzzbh=deleted.zzzbh

Answer 6

CREATE TRIGGER 名3 ON dbo.SGQYB
FOR delete
AS
delete TBBSB where ZZZBH  in (select ZZZBH  from deleted)

Answer 7

CREATE TRIGGER 名3 ON dbo.SGQYB
FOR delete
AS
delete TBBSB where ZZZBH  in (select ZZZBH  from deleted)

Answer 8

在删除SGQYB里的ZZZBH时同时删除TBBSB里对应的字段ZZZBHcreate trigger t_delete on sgqyb
for delete
delete from tbbsb where zzzbh in(select zzzbh from deleted)
go

Answer 9

hjb111(东方不败猪八戒)(西方失败唐老鸭) ( 
CrazyFor(蚂蚁) ( ) 信誉：262
你们的语法是不是有问题!
怎么通不过?

Answer 10

CREATE TRIGGER 名3 ON SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)

Answer 11

CREATE TRIGGER 名3 ON SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)

Answer 12

create trigger trig_SGQYB_delete on SGQYB
FOR delete
AS
delete TBBSB from deleted where TBBSB.ZZZBH = deleted.ZZZBH