请教一下各位高手，这样的触发器怎么写

[从今天开始吧]

建了一个触发器在tb1表上，当update表tb1时向表tb2写入被更新的数据，如果有多行这个触发器怎么写

[yesterday2000]

多行指的是什么？

[老宛]

CREATE TRIGGER trg_tb1
ON tb1
FOR UPDATE
AS
BEGIN
insert into tb2 select * from inserted
END
GO

[netcoder]

方法有几种，要看你的具体的需求了

[老宛]

更新了多行也可以，按语句触发呀

[老宛]

测试：
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


select * from tb2

go

update tb1 set a=5

go
select * from tb1
select * from tb2