【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-delete触发器.sql,希望本篇文章对您学习有所帮助。
/*打开数据库*/
USE mrdb
/*判断表中是否有名为employee_delete的触发器*/
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'song_delete' AND type = 'TR')
/*如果已经存在则删除*/
DROP TRIGGER song_delete
GO
/*创建新的删除触发器*/
CREATE TRIGGER song_delete
ON tb_12
FOR DELETE
AS
BEGIN
IF @@rowcount > 1
BEGIN
ROLLBACK TRANSACTION
RAISERROR ('你每次只能删除一条记录',16, 1)
END
END
GO