【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-实例318修改触发器.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
USE db_
sql2000
GO
/*判断表中是否有名为“tri_laborage_alter”的触发器*/
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = 'tri_laborage_alter'
AND type = 'TR')
/*如果已经存在则删除*/
DROP TRIGGER tri_laborage_alter
GO
CREATE TRIGGER tri_laborage_alter
ON tb_laborage17
AFTER DELETE AS
BEGIN
ROLLBACK TRANSACTION
PRINT('员工的工资信息不允许删除')
END
GO
--修改触发器
ALTER TRIGGER tri_laborage_alter
ON tb_laborage17
AFTER DELETE AS
DECLARE @员工编号 varchar(50)
SELECT @员工编号 = 员工编号 from deleted
IF @员工编号 in(SELECT 员工编号 FROM tb_employee17)
BEGIN
ROLLBACK TRANSACTION
PRINT('这个员工的信息不允许删除')
END
GO