摘要: --新增和删除触发器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 阅读(1460) 评论(0) 推荐(0) 编辑