这样的触发器是不能进行批量修改的,你是否进行了批量修改?
可以用游标实现:
CREATE TRIGGER AA ON [dbo].[TABLE1]
FOR UPDATE
AS
DECLARE @TID INT
DECLARE @ynn varchar(50)
DECLARE @ynnn varchar(50)
DECLARE @xnn varchar(50)
DECLARE @xnnn varchar(50)
DECLARE Employee_Cursor CURSOR FOR SELECT tid FROM deleted OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor into @tid
WHILE @@FETCH_STATUS = 0
BEGIN
select @ynn = tnn, @ynnn=tnnn from deleted where tid=@tid
select @xnn = tnn, @xnnn=tnnn from inserted where tid=@tid
insert into table2 (ynn, xnn, ynnn,xnnn) values (@ynn, @xnn, @ynnn, @xnnn)
FETCH NEXT FROM Employee_Cursor into @tid
END CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
可以用游标实现:
CREATE TRIGGER AA ON [dbo].[TABLE1]
FOR UPDATE
AS
DECLARE @TID INT
DECLARE @ynn varchar(50)
DECLARE @ynnn varchar(50)
DECLARE @xnn varchar(50)
DECLARE @xnnn varchar(50)
DECLARE Employee_Cursor CURSOR FOR SELECT tid FROM deleted OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor into @tid
WHILE @@FETCH_STATUS = 0
BEGIN
select @ynn = tnn, @ynnn=tnnn from deleted where tid=@tid
select @xnn = tnn, @xnnn=tnnn from inserted where tid=@tid
insert into table2 (ynn, xnn, ynnn,xnnn) values (@ynn, @xnn, @ynnn, @xnnn)
FETCH NEXT FROM Employee_Cursor into @tid
END CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货