注:
下面的实例由CSDN论坛MS-SQL server版块中internetcsdn (公元1979年8月10日) 网友提供
测试一.
--------------
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
/*
下面的实例由CSDN论坛MS-SQL server版块中internetcsdn (公元1979年8月10日) 网友提供
测试一.
--------------
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
/*