【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了实例316Rollback触发器.sql提供大家参考,希望对大家有所帮助!
USE db_
sql2000
GO
/*判断表中是否有名为“Add_Data”的触发器*/
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = 'Add_Data'
AND type = 'TR')
/*如果已经存在则删除*/
DROP TRIGGER Add_Data
GO
--创建触发器
CREATE TRIGGER Add_Data ON [dbo].[tb_employee17]
FOR INSERT
AS
--创建事务
BEGIN TRANSACTION
ROLLBACK TRANSACTION
INSERT INTO tb_laborage17 VALUES('1118',800, 100)