测试:
create table tb1
(
a int
)
go
create table tb2
(
a int
)
go
insert into tb1 select 1
insert into tb1 select 1
insert into tb1 select 1
insert into tb1 select 1
insert into tb1 select 1
insert into tb1 select 2
insert into tb1 select 2
insert into tb1 select 2
insert into tb1 select 3
insert into tb1 select 4
insert into tb1 select 5
go
select * from tb1
go
CREATE TRIGGER trg_tb1
ON tb1
FOR UPDATE
AS
BEGIN
insert into tb2 select * from inserted
END
GO