34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER [UpBomInfo] ON [dbo].[YT_CustBom_List]
FOR INSERT, UPDATE, DELETE
AS
If not exists(select 1 from inserted)
Begin
UpDate YT_Bom_List Set YT_Bom_LastTime = getDate() Where YT_Bom_Id=(Select YT_CostBom_BomId From inserted)
End