create table ta(ID int, name varchar(5), Content varchar(2)) insert ta select 1, '小明', '明' union select 2, '小张', '张' union select 3, '小曹', '曹'create trigger test_tr on ta instead of insert as set nocount on select * into # from ta where id>1 delete ta where id>1 insert ta select * from inserted insert ta select * from # 测试: insert ta select 4,'a','b' select * from ta
create table ta(ID int, name varchar(5), Content varchar(2))
insert ta
select 1, '小明', '明'
union select 2, '小张', '张'
union select 3, '小曹', '曹'create trigger test_tr on ta
instead of insert
as
set nocount on
select * into # from ta where id>1
delete ta where id>1
insert ta select * from inserted
insert ta select * from #
测试:
insert ta select 4,'a','b'
select * from ta