用游标最使用:以下是自己做的实验:
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