触发器 inserted deleted

3）显示触发器的定义:
sp_helptext:显示规则、默认值、未加密的存储过程、用户定义函数、触发器或视图的文本。
示例: EXEC sp_helptext '触发器名'

4）查看当前库中所有的触发器:
查询脚本：SELECT * FROM Sysobjects WHERE xtype = 'TR'

5）查看当前库中所有的触发器和与之相对应的表：
查询脚本：SELECT tb2.name AS tableName,tb1.name AS triggerName FROM Sysobjects tb1 JOIN Sysobjects tb2 ON tb1.parent_obj=tb2.id WHERE tb1.type='TR'

 

 

ALTER TRIGGER [TRIGGER_TB_YX_JYHTMX_DATA_d] ON [dbo].[TB_YX_JYHTMX_DATA]
after DELETE
AS
update  TB_YX_JYHT_DATA set n_slhj=(select sum(n_nhj) from TB_YX_JYHTMX_DATA where c_htid=(select c_htid from deleted)) where TB_YX_JYHT_DATA.c_htid=(select c_htid from deleted);

 

deleted   删除，更新，存在inserted表中 

 

 

ALTER TRIGGER [TRIGGER_TB_YX_JYHTMX_DATA_iu] ON [dbo].[TB_YX_JYHTMX_DATA]
after INSERT, UPDATE
AS
update  TB_YX_JYHT_DATA set n_slhj=(select sum(n_nhj) from TB_YX_JYHTMX_DATA where c_htid=(select c_htid from inserted)) where TB_YX_JYHT_DATA.c_htid=(select c_htid from inserted);

 

inserted  插入 更新