sql2000 如何用触发器实现级联删除

发布网友发布时间：2022-04-30 02:03

共3个回答

懂视网时间：2022-04-30 06:25

as declare @sno varchar(20) select @sno= sno from deleted delete from score where sno=@sno delete from student where sno=@sno go delete from Student where Sno=‘101‘ select *from Student select *from Score

sql-server数据库中利用触发器实现表与表之间的级联删除

标签：

热心网友时间：2022-04-30 03:33

下面是在user表上建立触发器的语句，在topic上建触发器的语句类似
CREATE
TRIGGER
deleteuser
ON
[dbo].[user]
INSTEAD
OF
DELETE
AS
DECLARE
@id
int;
--把数据类型改成与user_id一致
SELECT
@id=user_id
from
deleted;
DELETE
FROM
UT
WHERE
user_id=@id;
DELETE
FROM
user
WHERE
user_id=@id;
你把级联
DELETE
或
UPDATE取消掉就行了

热心网友时间：2022-04-30 04:51

delete
user
where
user_id
in
(select
user_id
from
UT
where
1=1)
delete
topic
where
topic_id
in
(select
topic_id
from
UT
where
1=1)
无须触发器.
直接用子删除语句即可实现.
不知满意否>
如果一定要用
也可以留言给我
继续作答