SQL 触发器 instead of | insert

create trigger tgr_Insert
on A
instead of insert
as
print 'Hello World'
go


insert into A values('100')--在触发器之前执行插入
go
select * from A
go

--禁用
disable trigger tgr_Insert on A 
go
--启用触发器
enable trigger tgr_Insert on A
go

  

原文地址:https://www.cnblogs.com/minotmin/p/3513417.html