USE [AIS20191016131710]
GO

The SET ANSI_NULLS ON
GO
The SET QUOTED_IDENTIFIER OFF
GO

ALTER the TRIGGER [dbo] [ICStock_Insert] ON [dbo] [ICStockBillEntry]
FOR the insert
AS
DECLARE @ InterID int, @ SUM_N int

Select @ SUM_N=SUM (inserted. FConsignAmount) from inserted
Select the top 1 @ InterID=inserted. FInterID from inserted
The update ICStockBill set FHeadSelfA9720=@ SUM_N where FInterID=@ InterID

Excuse me this trigger where there is a problem, why did not respond to a insert
Then always prompt object name "[dbo]. [ICStock_Insert]" invalid

CodePudding user response:

The ALTER is updated, you have the process
There is no use the CREATE

CodePudding user response:

At the bottom of the first to check the AIS20191016131710 library ICStockBillEntry have ICStock_Insert the trigger on the table

CodePudding user response:

Of course, there are ICStock_Insert the trigger

CodePudding user response:

There is the update action, it will need to use: the update, insert, and delete