delete触发器.sql

来自「这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代」· SQL 代码 · 共 23 行

/*打开数据库*/
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