轻松掌握设计 Sql Server触发器的原理

create trigger 触发器名 
on 表或视图
for|after|instead of --操作时机
insert,update,delete
as
sql语句

cust_test: CustomerID char(5) PK  order_test:
CustomerID char(5)--对应关系
Custcity                           Orderid    PK
Custname                           OrderNames
CStatus    int                     OStatus    int --状态
Cstorage   int                     Orders     int --定购量和库存量
Cdate      date                    Odate      date--日期

答案1：
use northwind
go
create trigger cust_orders_del1
on Cust_test
after delete
as 
delete from order_test
where CustomerID in
(select CustomerID from deleted)
go

答案2：
use northwind
go
create trigger cust_orders_ins2
on order_test
after insert
as
if (select cstatus from cust_test,inserted where 

cust_test.customerid=inserted.customerid)=1
begin
print 'The Goods is being processed'
rollback transaction
end
go

supdate,isdelete,isinsert,isafter,isinsteadof

无效：
use northwind
alter table 表名
disable trigger 触发器名

重新有效：
use northwind
alter table 表名
enable trigger 触发器名

use northwind
drop trigger 触发器名，触发器名