sqserver2008触发器——待续

CREATE TRIGGER INSERT_forbidden on s after INSERT
AS
BEGIN
    RAISERROR(‘禁止向s中插入数据‘,2,3)
    ROLLBACK--不加这一句不会回滚，抛错后将直接插入
END

CREATE TRIGGER trigger_name
 ON table_name
 [WITH ENCRYPTION]
  FOR | AFTER | INSTEAD OF [DELETE, INSERT, UPDATE]
 AS 
  T-SQL语句
GO
--with encryption 表示加密触发器定义的sql文本
--delete,insert,update指定触发器的类型