34,590
社区成员
发帖
与我相关
我的任务
分享
----------------------插入触发器inserted(批量)--------------------
CREATE trigger FOR_insert on tb
for insert
as
begin
insert into ta(qwe,rty)
select 1+a,'a'+b
from inserted
end
create table tb(id int,col varchar(10))
create table tb1(id int,col varchar(10))
go
create trigger addtotb1
on tb
after insert
as
begin
insert into tb1 select * from inserted
end
go
insert into tb select 1,'ABC'
select * from tb1
go
drop table tb,tb1
/*
id col
----------- ----------
1 ABC
(1 行受影响)
*/
楼主可以使用带OUTPUT参数的UPDATE.
UPDATE tb
SET COL1='XXX'
OUTPUT INSERTED.COL1,INSERTED.COL2 INTO @TB
create trigger tri_name on tb
for update
as
insert ta select * from inserted --inserted是修改后的记录 deleted是修改前的记录