当前位置: 代码迷 >> Sql Server >> 触发器的简单有关问题
  详细解决方案

触发器的简单有关问题

热度:72   发布时间:2016-04-27 20:18:25.0
触发器的简单问题
想创建一个禁止删除指定行的触发器,请问我错在哪里?
CREATE   TRIGGER   DelAdmin   ON   Account
FOR   DELETE,UPDATE
AS
IF   (Delete   from   Account   Where   usertypeid= '99 ')
BEGIN
ROLLBACK   TRANSACTION
END


------解决方案--------------------
CREATE TRIGGER DelAdmin ON Account
FOR DELETE,UPDATE
AS
IF (Delete from Account Where usertypeid= '99 ')
BEGIN
ROLLBACK TRANSACTION
END

-----------------------------------
CREATE TRIGGER DelAdmin ON Account
FOR DELETE,UPDATE
AS
Delete from Account Where usertypeid= '99 '
if @@rowcount> 0


BEGIN
ROLLBACK TRANSACTION
END


------解决方案--------------------

CREATE TRIGGER DelAdmin ON Account
FOR DELETE
AS
IF exists(select 1 from Account Where usertypeid= '99 ')
BEGIN
ROLLBACK TRANSACTION
END
  相关解决方案