create trigger [trigger name] on [table1 name]
for [insert][delete][update]
as
[insert][delete][update] [table2.name]
from
where [condition]
后面怎么写,from 后面跟的是什么意思
...全文
1288打赏收藏
菜鸟问题:触发器程序怎么写???
create trigger [trigger name] on [table1 name] for [insert][delete][update] as [insert][delete][update] [table2.name] from where [condition] 后面怎么写,from 后面跟的是什么意思
CREATE TRIGGER trig1
on authors
FOR INSERT, UPDATE, DELETE
AS
SELECT a.au_lname, a.au_fname, x.info
FROM authors a ,does_not_exist x
where a.au_id = x.au_id