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

CSgogogo 2003-08-26 09:56:28
问题很简单我没用过SQL SERVER
请问一个删除型的触发器怎么些
要求是:在删除SGQYB里的ZZZBH时同时删除TBBSB里对应的字段ZZZBH
一通过就结贴
快呀!
希望把里面写全!
...全文
72 13 打赏 收藏 转发到动态 举报
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
sdhdy 2003-08-26
  • 打赏
  • 举报
回复
create trigger trig_SGQYB_delete on SGQYB
FOR delete
AS
delete TBBSB from deleted where TBBSB.ZZZBH = deleted.ZZZBH
pengdali 2003-08-26
  • 打赏
  • 举报
回复
CREATE TRIGGER 名3 ON SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)
pengdali 2003-08-26
  • 打赏
  • 举报
回复
CREATE TRIGGER 名3 ON SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)
CSgogogo 2003-08-26
  • 打赏
  • 举报
回复
hjb111(东方不败猪八戒)(西方失败唐老鸭) (
CrazyFor(蚂蚁) ( ) 信誉:262
你们的语法是不是有问题!
怎么通不过?
zjcxc 元老 2003-08-26
  • 打赏
  • 举报
回复
在删除SGQYB里的ZZZBH时同时删除TBBSB里对应的字段ZZZBH

create trigger t_delete on sgqyb
for delete
delete from tbbsb where zzzbh in(select zzzbh from deleted)
go
happydreamer 2003-08-26
  • 打赏
  • 举报
回复

CREATE TRIGGER 名3 ON dbo.SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)
happydreamer 2003-08-26
  • 打赏
  • 举报
回复

CREATE TRIGGER 名3 ON dbo.SGQYB
FOR delete
AS
delete TBBSB where ZZZBH in (select ZZZBH from deleted)
CrazyFor 2003-08-26
  • 打赏
  • 举报
回复
Create trigger yourTriggerName on SGQYB
For Delete
As
Delete TBBSB from deleted where zzzbh=deleted.zzzbh
yujohny 2003-08-26
  • 打赏
  • 举报
回复
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
hjb111 2003-08-26
  • 打赏
  • 举报
回复
creat trigger T_deltable on sgqyb for delete
as
delete table tbbsb where zzzbh=deleted.zzzbh
go
hjb111 2003-08-26
  • 打赏
  • 举报
回复
creat trigger T_deltable on sgqyb
as
delete table tbbsb where zzzbh=deleted.zzzbh
go
txlicenhe 2003-08-26
  • 打赏
  • 举报
回复
Create trigger yourTriggerName on SGQYB
For Delete
As
Delete TBBSB where zzzbh in (Select zzzbh from deleted)
CSgogogo 2003-08-26
  • 打赏
  • 举报
回复
在删除SGQYB里的ZZZBH的一条记录的时同时删除TBBSB里对应的字段ZZZBH对应的一条记录

34,575

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧