首页 > 数据库技术 > 详细

[SQL]声明触发器 <待整理>

时间:2014-03-23 15:11:56      阅读:369      评论:0      收藏:0      [点我收藏+]
bubuko.com,布布扣
5./*声明触发器
create trigger dl_stu_mess4 on student for delete
as
declare @name_id int
select @name_id=stu.name from student stu,deleted d where stu.name=d.name
if exists(select * from books where books.name=@name_id)
delete from books where books.name=@name_id
print ‘jhsdjkjk‘
print @name_id
*/
/*
create trigger dl_stu_mess3 on books for delete
as
declare @name_id int
select @name_id=bo.name from books bo,deleted d where bo.name=d.name
if exists(select * from student where student.name=@name_id)
delete from student where student.name=@name_id
print ‘jhsdjkjk‘
print @name_id
*/
--sp_depends books 查看触发器
--sp_helptrigger student; 查看触发器信息
--drop trigger dl_stu_mess4; 删除触发器
insert into student values(2,4jkjjk,d,j,shs);
--delete from student where stu.name=2; 删除操作
select * from student;
--delete from books where books.name=2
--select * from books;
bubuko.com,布布扣

[SQL]声明触发器 <待整理>,布布扣,bubuko.com

[SQL]声明触发器 <待整理>

原文:http://www.cnblogs.com/beeone/p/3618640.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!