触发器

DML触发器 

Insert触发器

CREATE TRIGGER T_addMoney
ON dbo.Staff
FOR INSERT
AS
UPDATE dbo.Staff SET Money=Money+1 WHERE ID=(SELECT ID FROM Inserted)
--插入一条数据后自动将money+1

 Delete触发器

CREATE TRIGGER T_Delete
ON dbo.Staff
FOR DELETE
AS
SELECT * FROM Deleted
--删除后显示删除的内容

Update触发器

CREATE TRIGGER T_Update
ON dbo.Staff
FOR UPDATE
AS

IF    (UPDATE(Name) OR UPDATE(Sex))
BEGIN
    PRINT '基础数据不能更改'
    ROLLBACK TRANSACTION
END
ELSE
    PRINT '数据修改成功'

---

---

---

---

---

---

DDL触发器

CREATE TRIGGER T_notdelete
ON DATABASE
FOR DROP_TABLE,ALTER_TABLE
AS
    PRINT '事物不能被处理，基础数据表不能被修改和删除'
    ROLLBACK