当执行更新操作时 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
触发器
最新推荐文章于 2021-04-05 22:39:14 发布