CREATE TRIGGER DELETE_UserType
ON UserType
FOR DELETE
AS
UPDATE Users
SET UserType='普通用户'
FROM deleted AS d
WHERE UserType=d.UserType;
GO
ON UserType
FOR DELETE
AS
UPDATE Users
SET UserType='普通用户'
FROM deleted AS d
WHERE UserType=d.UserType;
GO
这是其它软件下的触发器吧。sqlserver中(2005版本及以前)并不支持行级触发器,都是按操作次触发,要实现行级操作要自己写循环(当然,简单的情况可以连表实现)。另外,sqlserver中没有before类型触发器,不过你可以根具你具体要实现的东西用,for,instead of,after等触发器来实现。
CREATE TRIGGER delete_UserType
ON UserType
FOR DELETE
AS
BEGIN
UPDATE a SET a.userType = '普通用户'
FROM users a
INNER JOIN deleted b
ON a.userType = b.UserType
END
http://technet.microsoft.com/zh-cn/library/ms189799(SQL.90).aspx