你想写什么动作就写什么动作,但不能ALTER DATABASE,CREATE DATABASE,DISK INIT,DISK RESIZE,DROP DATABASE,LOAD DATABASE,LOAD LOG,RECONFIGURE,RESTORE DATABASE,RESTORE LOG。如果有兴趣,看看这个触发器的动作:create table b( a int,b int) goinsert b values(1,1) insert b values(2,2) insert b values(3,3) insert b values(4,4) insert b values(5,5) insert b values(6,6) insert b values(7,7)create trigger Test_b on b for insert as delete b from inserted where b.a=inserted.a goinsert b select * from b goselect * from b 看看结果是什么?
你想写什么动作就写什么动作,但不能ALTER DATABASE,CREATE DATABASE,DISK INIT,DISK RESIZE,DROP DATABASE,LOAD DATABASE,LOAD LOG,RECONFIGURE,RESTORE DATABASE,RESTORE LOG。如果有兴趣,看看这个触发器的动作:create table b( a int,b int) goinsert b values(1,1) insert b values(2,2) insert b values(3,3) insert b values(4,4) insert b values(5,5) insert b values(6,6) insert b values(7,7)create trigger Test_b on b for insert as delete b from inserted where b.a=inserted.a goinsert b select * from b goselect * from b 看看结果是什么?
a int,b int)
goinsert b values(1,1)
insert b values(2,2)
insert b values(3,3)
insert b values(4,4)
insert b values(5,5)
insert b values(6,6)
insert b values(7,7)create trigger Test_b
on b
for insert
as
delete b
from inserted
where b.a=inserted.a
goinsert b select * from b
goselect * from b
看看结果是什么?
a int,b int)
goinsert b values(1,1)
insert b values(2,2)
insert b values(3,3)
insert b values(4,4)
insert b values(5,5)
insert b values(6,6)
insert b values(7,7)create trigger Test_b
on b
for insert
as
delete b
from inserted
where b.a=inserted.a
goinsert b select * from b
goselect * from b
看看结果是什么?