SQL - 18.触发器
语法:
CREATE TRIGGER triggerName ON Table
for UPDATE|INSERT|DELETE
AS
begin
…?
end
例:
create TRIGGER testForDel ON Category for DELETE AS BEGIN select * from book END GO
表category只要执行删除操作,就执行一次select * from book
未完。。
优质内容筛选与推荐>>