测试一.
--------------
create table tb1 (id int identity(1,1), a varchar(10))
create trigger tri_tb1 on tb1 INSTEAD OF insert
as
begin
insert tb1 (a)
select a from inserted
end
insert tb1(a)
select 'a'
select * from tb1
/*
id a
-----------------
1 a
*/
测试一.
--------------
create table tb1 (id int identity(1,1), a varchar(10))
create trigger tri_tb1 on tb1 for insert
as
begin
insert tb1 (a)
select a from inserted
end
insert tb1(a)
select 'a'
select * from tb1
/*
id a
-----------------
1 a
2 a
*/
==========================================================
结论:FOR INSERT,插入动作完成后执行触发语句.
INDSTEAD OF INSERT,用触发语句来代替插入语句.