关于插入多条记录时的触发器

[leonatcs]

触发器如下：

CREATE TRIGGER tr_monitee_insert ON [monitee]
after INSERT
AS
declare @a bigint
select @a=recno from inserted
insert into ch_mon (tbl,recno,type) values ('monitee',@a,'insert')

这个触发器只能应付插入一条记录的情况，如果是多条记录呢？
比如：
insert monitee select * from monitee

[paoluo]

CREATE TRIGGER tr_monitee_insert ON [monitee]
For INSERT
AS
insert into ch_mon (tbl,recno,type) Select 'monitee',recno,'insert' From Inserted
GO

[loverpyh]

接分!

[StarLoveCsdn]

up

[撸大湿]

CREATE TRIGGER tr_monitee_insert ON [monitee]
instead of INSERT
AS
insert into [monitee] (列1,列2,列3) Select 列1,列2,列3 From Inserted
insert into ch_mon (tbl,recno,type) Select 'monitee',recno,'insert' From Inserted

[youyu529]

CREATE TRIGGER tr_monitee_insert ON [monitee]
For INSERT
AS
insert into ch_mon (tbl,recno,type) Select 'monitee',recno,'insert' From Inserted
GO
就这样

[leonatcs]

呵呵,先谢谢诸位!!最近要不是通过csdn和请教大家，我可就郁闷大了！

[leonatcs]

再次感谢paoluo兄！