谭
谭俊峰
Unregistered / Unconfirmed
GUEST, unregistred user!
我想建立一个删除触发器，当该条纪录删除时，需要删除它的从表的所有ID=所删除的纪录的ID值，但我不知道如何获得该值。
D
djj
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE TRIGGER 触发器名 FOR 主库名 BEFORE DELETE POSITION 0 AS
BEGIN
DELETE FROM 从库 where 从库.id=主库.id
end
BEGIN
DELETE FROM 从库 where 从库.id=主库.id
end
H
hawkview
Unregistered / Unconfirmed
GUEST, unregistred user!
create triger trigername on tablename for delete as
if @@rowcount>1
begin
ROLLBACK TRAN
raiserror('you can only delete one at a time.',16,10)
end
declare @sstoredID char(10)
select @sstoredID =str_id
from deleted /*DELETED 是伪表由SQL SERVER生成来包存删除的记录值.
delete from detailtable where str_id=@sstoredid
if @@rowcount>1
begin
ROLLBACK TRAN
raiserror('you can only delete one at a time.',16,10)
end
declare @sstoredID char(10)
select @sstoredID =str_id
from deleted /*DELETED 是伪表由SQL SERVER生成来包存删除的记录值.
delete from detailtable where str_id=@sstoredid
G
gxg8816
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE TRIGGER "DN_DTrig" ON dbo.DN FOR DELETE AS
SET NOCOUNT ON
/* * CASCADE DELETES TO 'DN_detail' */
DELETE DN_detail FROM deleted, DN_detail WHERE deleted.DN_ID = DN_detail.DN_ID
SET NOCOUNT ON
/* * CASCADE DELETES TO 'DN_detail' */
DELETE DN_detail FROM deleted, DN_detail WHERE deleted.DN_ID = DN_detail.DN_ID
T
Tangqs
Unregistered / Unconfirmed
GUEST, unregistred user!
来晚了.
C
Crane
Unregistered / Unconfirmed
GUEST, unregistred user!
不用这么麻烦吧？我用ACCESS的连带删除功能就可实现你的要求，只需
一句SQL就行。
一句SQL就行。
G
gxg8816
Unregistered / Unconfirmed
GUEST, unregistred user!
如果是Access,就简单了,当然不用触发器(就没有触发器)
SQL SERVER下,只能写触发器
SQL SERVER下,只能写触发器
沈
沈前卫
Unregistered / Unconfirmed
GUEST, unregistred user!
Oracle下可使用触发器,也可以使用级联删除.
在定义库时加上.
Field1 VARCHAR2(20) NOT NULL REFERENCES tblOther(Field1) ON DELETE CASCADE
在定义库时加上.
Field1 VARCHAR2(20) NOT NULL REFERENCES tblOther(Field1) ON DELETE CASCADE
H
hawkview
Unregistered / Unconfirmed
GUEST, unregistred user!
总之要用到一伪表--DELETED，它是由SQL SERVER生成来包存删除的记录值的.
M
Mutex
Unregistered / Unconfirmed
GUEST, unregistred user!
如果是InterBase可以如下：
CREATE TRIGGER <trigger_name> FOR <MainTableName>
BEFORE DELETE AS
BEGIN
DELETE FROM <SubTableName> S WHERE Old.ID=S.ID
END
CREATE TRIGGER <trigger_name> FOR <MainTableName>
BEFORE DELETE AS
BEGIN
DELETE FROM <SubTableName> S WHERE Old.ID=S.ID
END
M
Mutex
Unregistered / Unconfirmed
GUEST, unregistred user!
sorry,忘了大于号问题了。
如果是InterBase可以如下：
CREATE TRIGGER trigger_name FOR main_table_name
BEFORE DELETE AS
BEGIN
DELETE FROM sub_table_name S WHERE Old.ID=S.ID
END
如果是InterBase可以如下：
CREATE TRIGGER trigger_name FOR main_table_name
BEFORE DELETE AS
BEGIN
DELETE FROM sub_table_name S WHERE Old.ID=S.ID
END
谭
谭俊峰
Unregistered / Unconfirmed
GUEST, unregistred user!
我在外地,未能及时回复,请多包含,
各位的热心参与,本人不胜感激.
各位的热心参与,本人不胜感激.