sql 新增后触发

不说语法，直接看代码

USE [shkj]
GO
/****** Object:  Trigger [dbo].[laserPrdTaskDetail_update]    Script Date: 11/14/2021 21:51:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--更新激光任务单状态
alter TRIGGER [dbo].[laserPrdTaskDetail_update] ON [dbo].[laserPrdTaskDetail] AFTER INSERT 
AS
BEGIN
   DECLARE @PID INT
   SELECT @PID = Inserted.PID
   FROM Inserted  

   
   UPDATE dbo.laserPrdTask SET  finishQty =b.qty FROM 
   dbo.laserPrdTask a INNER JOIN 
   (SELECT SUM(ISNULL(qty,0)) AS qty,PID FROM dbo.laserPrdTaskDetail WHERE PID = @PID GROUP BY  PID) AS b ON a.id = b.PID
   
   UPDATE dbo.laserPrdTask SET status = 1,finishDate = GETDATE() WHERE ISNULL(finishQty,0)>=taskQty AND id = @PID
   
    

END