MsgHeader   表         ID,SchoolNumber,Dates,UserTypeID  
  MsgStudBody表       ID,HeaderID,A,B,C  
  MsgClassBody表     ID,HeaderID,AA,BB,CC  
   
  如何实现当我删除MsgHeader表中记录时,   同时把MsgStudBody,MsgClassBody表中的记录删除  
   
  我用如下触发器,做,也不行,只能删除一条记录是可行  
  Create   TRIGGER   JXT2_DeleteMsgHeader   ON   MsgHeader   FOR   DELETE    
  AS  
  DECLARE   @HeaderID   int  
  DECLARE   @UserTypeID   int  
   
  SELECT   @HeaderID=ID,@UserTypeID=UserTypeID   FROM   deleted    
   
  IF   @UserTypeID   =   2  
  BEGIN  
      DELETE   FROM   MsgClassBody   WHERE   HeaderID   =   @HeaderID      
  END  
   
  IF   (@UserTypeID   =   1)   OR   (@UserTypeID   =   3)  
  BEGIN  
      DELETE   FROM   MsgStudBody   WHERE   HeaderID   =   @HeaderID  
  END