触发器简单分享记录

最新推荐文章于 2024-07-19 00:12:38 发布

小白在努力_*

最新推荐文章于 2024-07-19 00:12:38 发布

阅读量77

点赞数 2

文章标签：数据库 sql

本文链接：https://blog.csdn.net/dujunwoaini/article/details/139651785

版权

CREATE TRIGGER  Trg_TableName_Insert  --触发器名称
ON new_maintenancerecordinfo
instead of  UPDATE
AS
BEGIN
   SET NOCOUNT ON;
   -- 检查是否更新了特定的字段
    IF UPDATE(New_approvedetial)
	BEGIN
--
	update  new_maintenancerecordinfo set new_sssmwhf=danj.工时合计 * gys.New_workunit,new_asmwhf=danj.工时合计 * gys.New_workunit,new_ccsmwhf=danj.工时合计 * gys.New_workunit,new_fsmwhf=danj.工时合计 * gys.New_workunit
from   new_maintenancerecordinfo as wxzb 
join (select  new_maintenancerecordinfonew_maintena as 维修记录信息绑定 ,sum(new_workhoursnum) as 工时合计,new_maintenancerecordinfonew_maintenaName as 单据号 from new_maintenanceworkhoursinfo 
GROUP BY new_maintenancerecordinfonew_maintena,new_maintenancerecordinfonew_maintenaName
) as danj on wxzb.new_number=danj.单据号 and wxzb.new_maintenancerecordinfoid=danj.维修记录信息绑定
join account as gys on wxzb.new_accountnew_maintenancerecordinfo3 =gys.AccountId
where  gys.New_workunit is not null

END
END

go