create trigger test on table
for insert
as
exec 存储过程名
go
--存储过程如何调用触发器
create proc test
as
update table set ...
insert table select ...
delete table ...
--存储过程如何调用触发器
create proc test
as
update table set ...
insert table select ...
delete table ...