当前位置:Gxlcms > 数据库问题 > sql-server数据库中利用触发器实现表与表之间的级联删除

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

时间:2021-07-01 10:21:17 帮助过:2人阅读

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数据库中利用触发器实现表与表之间的级联删除

标签:

人气教程排行