SQL 触发器 instead of | insert

9/1/2015来源:SQL技巧人气:1055

SQL 触发器 instead of | insert
create trigger tgr_Inserton Ainstead of insertasprint 'Hello World'goinsert into A values('100')--在触发器之前执行插入goselect * from Ago--禁用disable trigger tgr_Insert on A go--启用触发器enable trigger tgr_Insert on Ago