触发器的简单问题
想创建一个禁止删除指定行的触发器，请问我错在哪里？
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
