sql server触发器复制表以及更新表

比较基础，仅此记录

复制表数据到另一个表中(两个表字段要相同)

CREATE TRIGGER [dbo].[copy]
ON [dbo].[table1]
WITH EXECUTE AS CALLER
FOR INSERT
AS
--
  begin
  insert into table2 select [Text1],[Text2] from inserted
  end
GO

当一个表字段更改，更改另一个表的

CREATE TRIGGER [dbo].[update]
ON [dbo].[table2]
WITH EXECUTE AS CALLER
FOR UPDATE
AS
--
  begin
  if EXISTS(select 1 from table1 A ,inserted B where A.ID=B.ID)--检查插入或更新的数据在表中是否存在，有则更新
  update table1 set [Status]=B.[Status] from inserted B
  where  table1.[TaskID]=B.[TaskID] 
  end
GO