Microsoft SQL Server 触发器更新、删除、插入表

//表插入CREATE TRIGGER INSERTDATE//INSERTDATE为触发器名称

ON A1 AFTER INSERT AS

BEGIN 

           INSERT INTOA2 (A2NAME) SELECT A1NAME FROM INSERTED

END

表同步插入

CREATE TRIGGER DELETEDATE//DELETEDATE 为触发器名

ON A1 AFTER DELETE AS
BEGIN 
 
          DELETE A2 WHERE A2 NAME IN(SELECT A1 NAME FROM DELETED)

END

//表同步删除

CREATE TRIGGER UPDATEDATE //Updatedate为触发器名

ON A1 AFTER UPDATE AS

BEGIN 

           UPDATE A2 SET A2.A2NAME=A1.A1NAME FROM A1 where A2.ID=A1.ID //将A1表内容传给A2

END

//表同步更新

//A1，A2，均为表名，A1NAME，ID为A1表列名，A2NAME，ID为A2表列名