USE [AIS20191016131710]
GOSET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GOALTER TRIGGER [dbo].[ICStock_Insert] ON [dbo].[ICStockBillEntry]
FOR insert
AS
DECLARE @InterID int,@SUM_N int select @SUM_N=SUM(inserted.FConsignAmount) from inserted
select top 1 @InterID=inserted.FInterID from inserted
update ICStockBill set FHeadSelfA9720=@SUM_N where FInterID=@InterID请问我这个触发器哪里有问题,为什么执行插入没有反应
然后总是提示对象名“[dbo].[ICStock_Insert]”无效
GOSET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GOALTER TRIGGER [dbo].[ICStock_Insert] ON [dbo].[ICStockBillEntry]
FOR insert
AS
DECLARE @InterID int,@SUM_N int select @SUM_N=SUM(inserted.FConsignAmount) from inserted
select top 1 @InterID=inserted.FInterID from inserted
update ICStockBill set FHeadSelfA9720=@SUM_N where FInterID=@InterID请问我这个触发器哪里有问题,为什么执行插入没有反应
然后总是提示对象名“[dbo].[ICStock_Insert]”无效
没有就用CREATE