触发器

 当执行更新操作时 delected inserted 两张表 相当于 先删除然后插入 ALTER TRIGGER 触发器名字 ON 做操作的表名 AFTER UPDATE AS BEGIN DECLARE @qNo varchar(20) SELECT @qNo=Contract_Id From deleted DECLARE @sNo varchar(20) SELECT @sNo=Contract_Id From inserted if @qNo!=@sNo begin UPDATE dbo.更新的表 set dbo.更新的表.IsOnFarm=1 where Contract_Id=@qNo end else begin UPDATE dbo.更新的表 set dbo.更新的表.IsOnFarm=0 where Contract_Id=@qNo end END GO 当执行删除操作时 delected ALTER TRIGGER 触发器名字 ON dbo.操作的表 AFTER DELETE AS BEGIN DECLARE @sNo varchar(20) SELECT @sNo=Contract_Id From deleted UPDATE dbo.更新的表set dbo.更新的表.IsOnFarm=1 where Contract_Id=@sNo END GO 本文来自优快云博客，转载请标明出处：http://blog.youkuaiyun.com/zq710860677/archive/2010/10/20/5954784.aspx