2008年6月23日触发器更新表:SQLServer 创建触发器,更新表
在SQLServer,触发器,插入、更新、删除状态: CREATE TRIGGER t_inms_alarms
ON [PHS].[dbo].[AlarmCurrent]
FOR INSERT, DELETE
AS
DECLARE @rows int
SELECT @rows = @@rowcount
IF @rows = 0
return
--如果表是插入,则同步更新AlarmsMiddleTbl
IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
BEGIN
INSERT ...
[阅读全文] [PDF]
1 共1条 分1页