sql server 中实现级联删除和级联更新

 1. 触发器方法

    create   Trigger  Trigger_Name     on  Table1    after  delete , UPDATE     as     begin      set  nocount  on ;       if   exists ( select   *   from  inserted)         update  Table2  set  field1  =  ( select  field1  from  inserted)  where  field1  =  ( select  field1  from  inserted)      else         delete   from  Table2  where  field1  =  ( select  field1  from  deleted)      set  nocount  off ;     end  

2. 创建外键关联关系

 

ALTER   TABLE  table1  ADD          CONSTRAINT   [ FK_Table1_Table2 ] FOREIGN   KEY (  field1)  REFERENCES  table2 (         field1        )  ON   UPDATE   CASCADE   ON   DELETE   CASCADE

 

 

 

 

转载于:https://www.cnblogs.com/lfzwenzhu/archive/2011/05/17/2048467.html