【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-xiaoshouupdate.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
create TRIGGER [dbo].[Trigger_xiaoshouUpdate]
ON [dbo].[xiaoshou]
AFTER delete
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
UPDATE kucun SET
kucun.数量= kucun.数量 - deleted.数量
FROM kucun INNER JOIN deleted
ON kucun.产品编号 = deleted.产品编号
UPDATE kucun SET
kucun.数量= kucun.数量 + inserted.数量
FROM kucun INNER JOIN inserted
ON kucun.产品编号 = inserted.产品编号
END