【SQL开源代码栏目提醒】:本文主要为网学会员提供实例317查看触发器数据.sql,希望对需要实例317查看触发器数据.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
EXEC sp_helptrigger 'tb_laborage17'