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

[CSgogogo]

问题很简单我没用过SQL SERVER
请问一个删除型的触发器怎么些
要求是:在删除SGQYB里的ZZZBH时同时删除TBBSB里对应的字段ZZZBH
一通过就结贴
快呀!
希望把里面写全!

[CSgogogo]

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

[txlicenhe]

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

[hjb111]

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

[hjb111]

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

[yujohny]

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

[CrazyFor]

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

[happydreamer]

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

[happydreamer]

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

[zjcxc]

在删除SGQYB里的ZZZBH时同时删除TBBSB里对应的字段ZZZBH

create trigger t_delete on sgqyb
for delete
delete from tbbsb where zzzbh in(select zzzbh from deleted)
go

[CSgogogo]

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

[pengdali]

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

[pengdali]

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

[sdhdy]

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