2012年5月30日
SQL Server触发器和事务
摘要： --新增和删除触发器alter trigger tri_TC on t_c for INSERT,deleteasbegin 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 阅读全文
posted @ 2012-05-30 16:50 ajunfly 阅读(1472) 评论(0) 推荐(0)