SQLServer触发器和事务用法示例

本文实例讲述了SQL Server触发器和事务用法。分享给大家供大家参考，具体如下：

新增和删除触发器

alter trigger tri_TC on t_c
  for INSERT,delete
as
begin
  set XACT_ABORT ON
  declare @INSERTCOUNT int;
  declare @DELETECOUNT int;
  declare @UPDATECOUNT int;
  set @INSERTCOUNT = (select COUNT(*) from inserted);
  set @DELETECOUNT = (select COUNT(*) from deleted);
  set @UPDATECOUNT = ()
  if(@INSERTCOUNT > 0)
  begin
   insert into t_c2 select * from inserted;
  end
  else if(@DELETECOUNT > 0)
  begin
   delete t_c2 where exists(select temp.cid from deleted temp where temp.cid=t_c2.cid);
  end
end

 

查看更多关于SQLServer触发器和事务用法示例的详细内容...